1-- In SESSION time zone
2SELECT current_timestamp FROM dual; -- 2021-05-07 05:36:57.476000
3SELECT current_timestamp(2) FROM dual; -- 2021-05-07 05:36:57.470000
4SELECT current_date FROM dual; -- 2021-05-07 05:36:57
5-- In SYSTEM on which database resides
6SELECT systimestamp FROM dual; -- 2021-05-07 07:36:57.762000 +02:00
7SELECT sysdate FROM dual; -- 2021-05-07 07:36:57