January 2, 0101

ownedbycats · 02-10-2022, 07:02 PM

The earliest available date for datetime fields is January 2, 0101. (January 1 just turns into undefined.)

Where does that come from? It doesn't match any of the epoches I'm aware of; I think Python itself runs on Unix time-- and a good thing Calibre doesn't, seeing as books existed before 1970.

kovidgoyal · 02-10-2022, 09:20 PM

It comes from limitations in various date/time handling libraries that I didnt feel like re-implementing. Timestamps in calibre are not stored using epochs but instead as ISO 8601 strings.

02-10-2022, 07:02 PM	#1
ownedbycats Custom User Title Posts: 11,408 Karma: 80995913 Join Date: Oct 2018 Location: Canada Device: Kobo Libra H2O, formerly Aura HD	January 2, 0101 The earliest available date for datetime fields is January 2, 0101. (January 1 just turns into undefined.) Where does that come from? It doesn't match any of the epoches I'm aware of; I think Python itself runs on Unix time-- and a good thing Calibre doesn't, seeing as books existed before 1970.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Amazon US spend $XX get $YY credit - October 10 to October 16	sufue	Deals and Resources (No Self-Promotion or Affiliate Links)	109	10-15-2022 12:05 PM
Free January 24-25	cockroachal	Self-Promotions by Authors and Publishers	0	01-24-2019 12:50 PM
published dates before feb 0101 CE	readerboy7	Library Management	1	01-21-2016 06:24 AM
January 101	JCSullivan	Library Management	3	04-21-2012 10:58 PM
Date for added books defaults to 01 Jan 0101?	PatNY	Calibre	7	04-09-2012 05:07 PM

02-10-2022, 09:20 PM	#2
kovidgoyal creator of calibre Posts: 45,712 Karma: 28549306 Join Date: Oct 2006 Location: Mumbai, India Device: Various	It comes from limitations in various date/time handling libraries that I didnt feel like re-implementing. Timestamps in calibre are not stored using epochs but instead as ISO 8601 strings.

Advert