![]() |
#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! |
![]() |
![]() |
![]() |
#2 |
creator of calibre
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 44,205
Karma: 23446406
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 | |
|
![]() |
#3 |
Well trained by Cats
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 30,188
Karma: 57532382
Join Date: Aug 2009
Location: The Central Coast of California
Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A
|
![]() |
![]() |
![]() |
![]() |
#4 | |
null operator (he/him)
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 20,791
Karma: 27405122
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 |
|
![]() |
||||
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 |