search using date AND time

johnzondag · 07-17-2019, 10:40 AM

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!

kovidgoyal · 07-17-2019, 10:51 AM

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

theducks · 07-17-2019, 12:43 PM

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

BetterRed · 07-17-2019, 08:29 PM

Quote:

Originally Posted by johnzondag

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

07-17-2019, 10:40 AM	#1
johnzondag Junior Member Posts: 1 Karma: 10 Join Date: Jul 2019 Device: Calibre	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!

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
[need help] search by Date	nqk	Library Management	1	09-29-2018 12:59 AM
"date" reports correct time zone and time; UI reports a time several hours off	Synthead	Kindle Developer's Corner	17	01-05-2015 06:10 AM
Search for time range possible? And date question	manawydan	Library Management	5	11-15-2013 06:33 PM
Search on Added Date	nynaevelan	Calibre	6	11-10-2010 10:15 PM
Search date..	ottovdv	Calibre	1	10-26-2010 05:29 AM

07-17-2019, 10:51 AM	#2
kovidgoyal creator of calibre Posts: 45,610 Karma: 28549044 Join Date: Oct 2006 Location: Mumbai, India Device: Various	No only date searchis implemented, you can always get the date value yourself via calibredb and searchusing it in your scripts.

07-17-2019, 12:43 PM	#3
theducks Well trained by Cats Posts: 31,270 Karma: 61916422 Join Date: Aug 2009 Location: The Central Coast of California Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A	Sorting on a 'date' type does order them by time stamp