TO_DATE in SQL

TO_DATE in SQL

Alternatively, you may use TO_DATE explicitly:

insert into x
values(99, to_date('1998/05/31:12:00:00AM', 'yyyy/mm/dd:hh:mi:ssam'));

The general usage of TO_DATE is:

TO_DATE(, '')