Re: [sqr-users] SQL Insert

["Jamie Harris" <JHarris@frederick.edu>]

I always do dates as 'yyyy-mm-dd' on SQL server.  Try that and see if it
helps. :)

-----------------------------------------------------
James Harris
Junior Systems Programmer/Analyst
Information Technology Division
Frederick Community College
-----------------------------------------------------

>>> KParker@magnatrax.com 11/18/2002 3:33:31 PM >>>
I'm trying to insert into a date in the format of "yyyymmdd" into a 
sql database & get the error below.  Can anyone tell how a date should
be formatted for sql?

Could not insert the following data into the database: 
SQL Error Message = [Microsoft][ODBC SQL Server Driver][SQL
Server]Syntax error converting datetime from character string.

Thanks

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org 
http://www.sqrug.org/mailman/listinfo/sqr-users
BEGIN:VCARD
VERSION:2.1
X-GWTYPE:USER
FN:Harris, Jamie
TEL;WORK:2668
ORG:Work;Division of Information Technology
EMAIL;WORK;PREF:JHarris@frederick.edu
N:Harris;Jamie
TITLE:Systems Analyst, PeopleSoft
ADR;DOM;WORK;PARCEL;POSTAL:;L-205
LABEL;DOM;WORK;PARCEL;POSTAL;ENCODING=QUOTED-PRINTABLE:Harris, Jamie=0A=
L-205
END:VCARD