Oracle Express Edition 11g
SELECT
CURRENT_TIMESTAMP AS before_currdate,
CURRENT_DATE AS currdate,
CURRENT_TIMESTAMP AS after_currdate
FROM DUAL;
|BEFORE_CURRDATE |CURRDATE |AFTER_CURRDATE |
|-----------------------|-----------------------|-----------------------|
|2020-12-11 10:02:18.941|2020-12-11 10:02:18.000|2020-12-11 10:02:18.000|