There is a built-in function call (todate) that I have yet to figure out how to access using DBD::Oracle.

Try this in your SQL:

UPDATE table SET dateColumn = TO_DATE ('2002-08-12', 'YYYY-MM-DD')
[download]

-- vek --