Date:         Mon, 10 May 2004 02:28:24 -0700
Reply-To:     Loi Tan Vo <loi.tan.vo@FNH.NO>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Loi Tan Vo <loi.tan.vo@FNH.NO>
Organization: http://groups.google.com
Subject:      Insert into MS SQL 2000 by using SAS
Content-Type: text/plain; charset=ISO-8859-1

Hi all,

I have a odbc connecting to MS SQL server 2000 and want by using SAS
data step to insert data into a table in MS SQL. For ex.

Proc sql;
INSERT INTO sqllib.Table1(id, Name, Fromdate, tildate)
VALUES(2,'statistic_1','01/01/2004'd,'31/01/2004'd);
run;

Then I got the followings errors
ERROR: Invalid date/time/datetime constant '01/01/2004'd
ERROR: Invalid date/time/datetime constant '31/01/2004'd

How to convert datetime so that the ms sql can understand the
datetime?

Thanks in advance

- Loi -