add remove split language show hidden hide
db<>fiddle
donate feedback about
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
TO_DATE('01/01/201600:00:00','MM/DD/YYYYHH24:MI:SS') DUMP(TO_DATE('01/01/201600:00:00','MM/DD/YYYYHH24:MI:SS'),1016)
 2016-01-01 00:00:00 Typ=13 Len=8: e0,7,1,1,0,0,0,0
TO_DATE('01/01/2016','MM/DD/YYYY') DUMP(TO_DATE('01/01/2016','MM/DD/YYYY'),1016)
 2016-01-01 00:00:00 Typ=13 Len=8: e0,7,1,1,0,0,0,0
DATE'2016-01-01' DUMP(DATE'2016-01-01',1016)
 2016-01-01 00:00:00 Typ=13 Len=8: e0,7,1,1,0,0,0,0
CAST(TIMESTAMP'2016-01-0100:00:00'ASDATE) DUMP(CAST(TIMESTAMP'2016-01-0100:00:00'ASDATE),1016)
 2016-01-01 00:00:00 Typ=13 Len=8: e0,7,1,1,0,0,0,0