search using date AND time
 

Hi,

I'm using a script to list some books and save them:
calibredb list -s 'last_modified:>2019-07-16' -f id| .....

Is it possible to add the time to the date? I've tried:
2019-7-16_13:00:00 (with underscore)
2019-7-16 13:00 (only hours/minutes)
2019-7-16 13:00:00:000 (hours, minutes, seconds, miliseconds)
"2019-7-16 13:00:00" (embedded in double quotes)

I get no warning on the date format, but no results either. I've also looked at the advanced search in the GUI, but haven't found a workable format for date+time. When sorting in the GUI I can see that the hours/minutes/seconds are present.

Any ideas would be much appreciated!

No only date searchis implemented, you can always get the date value yourself via calibredb and searchusing it in your scripts.

:bulb: Sorting on a 'date' type does order them by time stamp

Long shot - try something like this 1968-04-09T14:22:34

Be good if time could be included in search: I use date format (mm:ss) to store video duration times.

BR