Robert Hicks wrote: > 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') ?
Yeah, sorry -- that should have been TO_DATE. Philip
