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 |