View Single Post
Old 07-17-2019, 07:29 PM   #4
BetterRed
null operator (he/him)
BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.
 
Posts: 21,752
Karma: 30237526
Join Date: Mar 2012
Location: Sydney Australia
Device: none
Quote:
Originally Posted by johnzondag View Post
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!
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

Last edited by BetterRed; 07-17-2019 at 07:31 PM. Reason: missed KG's post
BetterRed is offline   Reply With Quote