07-17-2019, 09:40 AM | #1 |
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! |
07-17-2019, 09:51 AM | #2 |
creator of calibre
Posts: 43,858
Karma: 22666666
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.
|
Advert | |
|
07-17-2019, 11:43 AM | #3 |
Well trained by Cats
Posts: 29,801
Karma: 54830978
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
|
07-17-2019, 07:29 PM | #4 | |
null operator (he/him)
Posts: 20,568
Karma: 26954694
Join Date: Mar 2012
Location: Sydney Australia
Device: none
|
Quote:
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 |
|
Tags |
calibredb, date format, search, time |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
[need help] search by Date | nqk | Library Management | 1 | 09-28-2018 11:59 PM |
"date" reports correct time zone and time; UI reports a time several hours off | Synthead | Kindle Developer's Corner | 17 | 01-05-2015 05:10 AM |
Search for time range possible? And date question | manawydan | Library Management | 5 | 11-15-2013 05:33 PM |
Search on Added Date | nynaevelan | Calibre | 6 | 11-10-2010 09:15 PM |
Search date.. | ottovdv | Calibre | 1 | 10-26-2010 04:29 AM |