Personally I'd forgo a few millennia in exchange for more accuracy :-) Sam
------------------------------------------- We're Hiring! Seeking a passionate developer to join our team building products. Position is in the Washington D.C. metro area. If interested contact [EMAIL PROTECTED] -----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 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 +143027-10-14 08:59:00.991 (CE) All dates in this range are accurate to 1/1000 of a second I have helper routines for date arithmetic and converting to/from Julian dates, UNIX dates and Delphi TDateTime. There is also a parser for ISO8601 formatted strings for the following formats: General dates - 2007-03-05 12:34:56.789 Day of Year dates - 2007-365 Week dates - 2007-W51-7 If anyone would find this useful/helpful please let me know. Tom tolson at whamware.com ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
