convert timestamp to date oracle 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)