Oracle Timestamp

update customer set timestamp=to_date('1998/05/31:12:00:00AM', 'yyyy/mm/dd:hh:mi:ssam') where customer_id=48303

More Info:
http://infolab.stanford.edu/~ullman/fcdb/oracle/or-time.html