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

2007-03-09 Thread Samuel R. Neff 

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]
-

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

2007-03-08 Thread Tom Olson 

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]
-