Oracle 21c

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

CREATE TABLE test (ts TIMESTAMP, dd DATE)
INSERT INTO test VALUES (SYSTIMESTAMP, SYSTIMESTAMP)
1 rows affected

SELECT ts, dd, CAST(dd AS TIMESTAMP) FROM test


TS
DD
CAST(DDASTIMESTAMP)


29-MAR-23 15.38.15.275094
29-MAR-23
29-MAR-23 15.38.15.000000