Peter J. Holzer wrote:
On 2006-10-18 10:19:24 -0400, Hardy Merrill wrote:
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.
The date format is wrong. If you tell Oracle to expect a date in
MM/DD/YYYY format and then feed it a string like '2006-09-15 00:00:00'
it will complain that they don't match. You will eitther have to change
the format string to match the actual date format (i.e., 'YYYY-MM-DD
HH24:MI:SS') or change the date format to match the format string.
I did...and I realized my mistake when that error came up. : )
Robert
