I would use Oracle's built-in to_date(datestring, formatstring) function, e.g.:

   UPDATE table SET date_field = to_date(?, 'YYYYMMDDHH24MISS')
   WHERE id = ?
[download]

, assuming of course that by "hh" you mean 24-hour.

If not P, what? Q maybe?
"Sidney Morgenbesser"