Subject | the date/time size question: msg 11980 |
---|---|
Author | csswa |
Post date | 2002-05-02T19:35:40Z |
I apologise for reposting this, but it worries me and I want to be
clear about it.
Can anyone confirm that the quote from Langref.pdf (at bottom) is a
typo (DATE and TIME *are not* 8-bytes).
Regards,
Andrew Ferguson
-- Subliminimal messiahages aAndrewund.
from datadef p.70:
DATE stores a date as a 32-bit longword. Valid dates are from January
1, 100 a.d. to February 29, 32768 a.d.
TIME stores time as a 32-bit longword. Valid times are from 00:00 AM
to 23:59.9999 PM.
TIMESTAMP is stored as two 32-bit longwords and is a combination of
DATE and TIME.
from langref p.19-20:
DATE 64 bits 1 Jan 100 a.d. to 29 Feb 32768 a.d. ISC_DATE
TIME 64 bits 0:00 AM to 23:59.9999 PM ISC_TIME
clear about it.
Can anyone confirm that the quote from Langref.pdf (at bottom) is a
typo (DATE and TIME *are not* 8-bytes).
Regards,
Andrew Ferguson
-- Subliminimal messiahages aAndrewund.
from datadef p.70:
DATE stores a date as a 32-bit longword. Valid dates are from January
1, 100 a.d. to February 29, 32768 a.d.
TIME stores time as a 32-bit longword. Valid times are from 00:00 AM
to 23:59.9999 PM.
TIMESTAMP is stored as two 32-bit longwords and is a combination of
DATE and TIME.
from langref p.19-20:
DATE 64 bits 1 Jan 100 a.d. to 29 Feb 32768 a.d. ISC_DATE
TIME 64 bits 0:00 AM to 23:59.9999 PM ISC_TIME