x27;m
getting hung up on converting the date TO the 5 digit format.
Thanks!
-V
-Original Message-
From: Andy Parry [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 13, 2002 12:24 AM
To: CF-Talk
Subject: RE: Date/Time to Numeric Date
Vinny,
dates in most DB's are stored in a nume
EMAIL PROTECTED]]
Sent: Wednesday, February 13, 2002 12:24 AM
To: CF-Talk
Subject: RE: Date/Time to Numeric Date
Vinny,
dates in most DB's are stored in a numeric format representing the number
of
days since the base reference date,
eg. SQL Server = Jan 1, 1753 for a datetime or Jan 1
Vinny,
dates in most DB's are stored in a numeric format representing the number
of
days since the base reference date,
eg. SQL Server = Jan 1, 1753 for a datetime or Jan 1, 1900 for
smalldatetime.
Different DB;s use different reference dates. eg. I think Pick Universe u
ses
31 Dec 1967.
try
3 matches
Mail list logo