to_date in oracle with timestamp 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 to_date
SELECT
TO_DATE( '21 12 2017', 'DD MM YYYY' )
FROM
dual;
---or----
INSERT INTO members(first_name, last_name, joined_date)
VALUES('Laureen','Davidson', TO_DATE('2017/12/21','YYYY/MM/DD'));