LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (August 2001, week 1)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Tue, 31 Jul 2001 10:08:29 +0300
Reply-To:     Kamal_ahmed@alfalak.com
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"

Hello,

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. _________________________________ Osama Keshtah Software Consultant SAS Division, ALFALAK, SAUDI ARABIA E-mail: osama_keshtah@alfalak.com Tel 966 (3) 882-9996 Ext 193 - Fax 966 (3) 882-2156 __________________________________


Back to: Top of message | Previous page | Main SAS-L page