Re: ODBC INSERT with parameter markers and TO_DATE

[Quoted] try using the ODBC data format.

[Quoted] You can use an ANSI date format via an ODBC escape:

{ d '1981-12-03' }

Note that this is enclosed in single quotes and always of the format YYYY-MM-DD. You can always use the standard Oracle date format in much the same way:

{ '03-Dec-1981' }

Time may be specified as follows:

{ t 'hh:mm:ss' }

A timestamp, (date including time), can be done with the following format:

{ ts '1981-12-03 00:00:00' }
Received on Wed Feb 25 1998 - 00:00:00 CET