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
Tom Olson wrote:
>
> 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 current
> implementation is in Delphi. Would anyone be interested in such a
> feature?
>
> Tom
>
--
View this message in context:
http://www.nabble.com/ISO8601-8-byte-packed-date-type-tf3364823.html#a9388503
Sent from the SQLite mailing list archive at Nabble.com.
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
