By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| CAST(TRUNC(SYSDATE-1)ASTIMESTAMP)+INTERVAL'8'HOUR+INTERVAL'40'MINUTE+INTERVAL'20'SECOND |
|---|
| 08-JUN-20 08.40.20.000000000 |
| CAST(TRUNC(SYSDATE-1)ASTIMESTAMP)+INTERVAL'8'HOUR+INTERVAL'40'MINUTE+INTERVAL'20'SECOND |
|---|
| 08-JUN-20 08.40.20.000000000 |