Oracle: use timestamp to convert string to date

http://www.xinotes.org/notes/note/422/

You can use the timestamp keyword to convert a string to Date:

select * from retail_transactions where posted_date >= timestamp '2008-12-01 00:00:00';