> I'm trying to insert a date into an Oracle table and get the following
> error. Help!!
>
> Error Diagnostic Information
> ODBC Error Code = 37000 (Syntax error or access violation)
> [Oracle][ODBC Oracle Driver][Oracle OCI]ORA-00917: missing comma.
> SQL = "INSERT INTO emirf (FIRST_NAME, REQUEST_DATE, LAST_NAME) VALUES (
> 'Lisa',to_date('26-Apr-2001','DD-MMM-YYYY','Lisa' )"
> Data Source = "ADMS"
In addition to the error pointed out by Chis, the format for an abbreviated
month is MON. I wrote it like this for a test:
select to_date('26-Apr-2001','DD-MON-YYYY') from dual;
It returns:
4/26/01
Russell Conway
HallofSports.com, Inc.
351 West 22nd Street
New York, NY 10011
P (646) 638-2500
F (561) 423-2674
http://www.hallofsports.com
.. . . where the legends live on
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
