to_tımestamp
582889Jan 4 2008 — edited Jan 4 2008when I try thıs query the followıng error message ıs returned.
ORA-01830: date format picture ends before converting entire input string
SELECT snap_id, begin_interval_time
FROM dba_hist_snapshot
WHERE begin_interval_time between
TO_TIMESTAMP('02-JAN-08 09.00.00 AM')
and
TO_TIMESTAMP('03-JAN-08 19.00.00 PM');