Sorry for the top-post - Groupwise :-( Notice how Philip suggested using "to_char" - *not* "to_date". You probably already know this, but on the chance you don't, you use "to_date" if you have a string that contains a date and you want to put that date into a "DATE" column in the database. You use "to_char" if you want to pull a "DATE" column out of the database into a string (scalar) variable. HTH. Hardy Merrill
>>> Robert Hicks <[EMAIL PROTECTED]> 10/17/2006 8:32 PM >>> 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
