RE: [sqlite] ISO8601 8-byte packed date type

] -Original Message- From: Tom Olson [mailto:[EMAIL PROTECTED] Sent: Thursday, March 08, 2007 11:50 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] ISO8601 8-byte packed date type I was pretty tires when I wrote the original post and realize that I should have been more specific. So here

Re: [sqlite] ISO8601 8-byte packed date type

I was pretty tires when I wrote the original post and realize that I should have been more specific. So here goes! I have created an 8-byte packed data type that stores date, time and timezone information. It has an effective date range of: -142399-01-01 00:00:00.000 (BCE) through

[sqlite] ISO8601 8-byte packed date type

Hello to all, I am working on an 8-byte data type that stores date time and timezone information and provides helper routines for date arithmatic as well as conversion to/from strings, julian dates, UNIX date times, etc... The type can be stored in a 64-bit integer or as an 8 byte blob. The