Yes that looks correct. If you're still having trouble with it, reply back and post the small section of code that you're having trouble with, and the error you are getting. Hardy Merrill
>>> Robert Hicks <[EMAIL PROTECTED]> 10/18/2006 10:11 AM >>> Hardy Merrill wrote: > 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 I think I get it yes. So here is what I am doing. Access has a date field that I am pulling out and when I print the "$start_date" variable it looks like this: 2006-09-15 00:00:00 That is a string now to Perl...correct? Now I am inserted that string into the Oracle database as a DATE. So I am doing, using the variable from the bindcolumn parameter: TO_DATE($start_date, 'MM/DD/YYYY') to insert that string into Oracle as a DATE and passing in the date format along with it. Do I have that right? Robert
