Oracle TO_DATE( ) this afternoon
Just being asked to convert string "1/1/2020 0:00' to date field in Oracle, and come up with this:
select to_date('1/1/2020 0:00', 'dd/mm/yyyy hh24:mi') from dual
Just being asked to convert string "1/1/2020 0:00' to date field in Oracle, and come up with this:
select to_date('1/1/2020 0:00', 'dd/mm/yyyy hh24:mi') from dual
Comments
Post a Comment