By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| BANNER | BANNER_FULL | BANNER_LEGACY | CON_ID |
|---|---|---|---|
| Oracle Database 21c Express Edition Release 21.0.0.0.0 - Production | Oracle Database 21c Express Edition Release 21.0.0.0.0 - Production Version 21.3.0.0.0 |
Oracle Database 21c Express Edition Release 21.0.0.0.0 - Production | 0 |
| SYSDATE | SYSDATE-1 | SYSDATE-1.1 | SYSDATE-1.5 | SYSDATE-1.9 |
|---|---|---|---|---|
| 07-APR-23 | 06-APR-23 | 06-APR-23 | 06-APR-23 | 05-APR-23 |
| SYSDATE | END_OF_MONTH | LAST_DAY(SYSDATE)-SYSDATE | LAST_DAY(SYSDATE)-TRUNC(SYSDATE) |
|---|---|---|---|
| 07-APR-23 | 30-APR-23 | 23 | 23.86894675925925925925925925925925925926 |
| TRUNC(LAST_DAY(SYSDATE))-SYSDATE | LAST_DAY(SYSDATE)-TRUNC(SYSDATE) |
|---|---|
| 22.13105324074074074074074074074074074074 | 23.86894675925925925925925925925925925926 |