Convert string to date It is quite handy to be able to convert strings to dates, when working with Oracle databases. TO_DATE('2003/07/09', 'yyyy/mm/dd') References Source