DATE datatype

From: Frank Maxey <76373.1101_at_CompuServe.COM>
Date: Thu, 18 Mar 1999 08:06:04 -0500
Message-ID: <#3GXVAUc#GA.56_at_nih2naaa.prod2.compuserve.com>

For the DATE datatype, the time/date 30ct, 1999 would be stored internally in 7 bytes as:

        119 199 11 30 1 1 1

What would be the internal storage pattern for the same date in 2000? 1st guess is:

        120 100 11 30 1 1 1

Is this correct?

I ask this because we're having problems with the year 2000 during a select using the DATE datatype field.

Thanks in advance

Frank Maxey
Siemens E&A, Inc.
100 Technology Drive
Alpharetta, GA 30005

Phone:	(770) 740-3374		E-mail: fmaxey_at_compuserve.com
Fax:		(770) 740-3464

-- 
Frank Maxey
Siemens E&A, Inc.
fmaxey_at_compuserve.com

Received on Thu Mar 18 1999 - 14:06:04 CET