How to query data by datepickerrange

Dash Python
1

I have set one datepickerrange in dash.
How I can query MySQL database data by datepikerrange?

In MySQL, it can run as below pic.

image
image1356×516 58 KB

And the script in dash as below. But it get the empty result.

image
image1816×1144 332 KB

Is there any wrong in my script?

2

start_date ( string ; optional): Specifies the starting date for the component. Accepts datetime.datetime objects or strings in the format ‘YYYY-MM-DD’.

end_date ( string ; optional): Specifies the ending date for the component. Accepts datetime.datetime objects or strings in the format ‘YYYY-MM-DD’.

sql=f'select * from abc where TIME between {start_date} and {end_date}'

3

The column in MySQL already is the datetime format.
The datepickrange should be change to the datetime format?