Posted by Bob A on September 16, 2009 at 07:34:53:
In Reply to: Re: Date data type posted by Jim Guerber on September 15, 2009 at 11:04:38:
"As a start, look at the windows way of dealing with dates. Don't forget time as well."
I think there are two "Windows" ways....
1) Windows the operating system, which is milliseconds since 00h00m00s GMT on 1970-01-01 which includes both date and time in one number
2) Windows Office which is days since 1899-10-30 followed by a fraction representing percent of a day (24 hours)
since there is a long standing bug in the second date (see: http://support.microsoft.com/kb/214326 ), I would surely propose keeping with the COMET serial number of days as the base for elapsed days.
Although I will not profit from it, as I have COMET16, the COMET32 limit on the size of the numbers would easily allow the first option (milliseconds) since we have access to this number easily thru NUM2DATE (Option #6)
Bob "A"
Each file can be a maximum of 1MB in length Uploaded files will be purged from the server on a regular basis.