Oracle 11g Release 2

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE table_name ( old_timestamp_column TIMESTAMP(6) );
INSERT INTO table_name VALUES ( SYSTIMESTAMP );
1 rows affected

ALTER TABLE table_name ADD new_date_column DATE;
UPDATE table_name
SET new_date_column = old_timestamp_column;
1 rows affected

UPDATE table_name
SET new_date_column = CAST( old_timestamp_column AS DATE );
1 rows affected

ALTER SESSION SET NLS_TIMESTAMP_FORMAT = 'YYYY-MM-DD HH24:MI:SS.FF6';
ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS';
SELECT * FROM table_name;


OLD_TIMESTAMP_COLUMN
NEW_DATE_COLUMN


2019-11-18 12:59:45.274895
2019-11-18 12:59:45


UPDATE table_name
SET new_date_column = TRUNC( old_timestamp_column );
1 rows affected

SELECT * FROM table_name;


OLD_TIMESTAMP_COLUMN
NEW_DATE_COLUMN


2019-11-18 12:59:45.274895
2019-11-18 00:00:00