Date: Tue, 31 Jul 2001 10:08:29 +0300
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Osama Keshtah <osama_keshtah@ALFALAK.COM>
Subject: ERROR in DATE column during acceess to SQL (in JMP)
Content-Type: text/plain; charset="iso-8859-1"
I Try to use access to SQL data through ODBC, and I got data successfully
form SQL server except date column.
All of date records contains one wrong value 01/01/1904
The format for date in SQL is mm/dd/yyyy and length is 8
How we can get this date column with correct value from SQL through ODBC
Note: When save SQL data as excel file and try to open this excel file.
Date column was coming as correct value.
SAS Division, ALFALAK,
Tel 966 (3) 882-9996 Ext 193 - Fax 966 (3) 882-2156