oracle to_timestamp code example

Example 1: oracle to_timestamp

-- TO_TIMESTAMP(date_string,'YYYY-MM-DD HH24:MI:SS')
SELECT TO_TIMESTAMP('13/02/2021 23:12:01','YYYY-MM-DD HH24:MI:SS') FROM DUAL;

Example 2: oracle timestamp to date

CAST(timestamp_expression AS DATE)