Garrett, Philip (MAN-Corporate) wrote:
Robert Hicks wrote:
Any gotchas there? I am opening an Access db via ODBC and binding
those columns (including a date field) and passing that to the Oracle
handle to do inserts (i.e. Access -> Oracle migration).
Only gotcha is with formatting -- you'll need to either:
1) "alter session set nls_date_format = '...'" to the date format you're
supplying Oracle, or:
2) use to_char(?,'...') on the date fields
Philip
Oracle won't accept it if I do TO_DATE($start_date, 'DD/MM/YYYY') ?
Robert
