Oracle current timestamp

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

Source: stackoverflow.com

Similar codes

0 vote103 views1 answer
Mysql add text to existing field
SQL
0 vote120 views1 answer
Mysql dump for selected row
SQL
3 votes123 views1 answer
Oracle cannot access v$session
SQL
0 vote119 views1 answer
What is top n result in sql
SQL
0 vote117 views1 answer
Window function to forward fill
SQL
2 votes109 views3 answers
Current month mysql query
SQL
0 vote109 views1 answer
Select last N rows mysql
SQL
0 vote123 views2 answers
Null value in column violates not-null constraint
SQL
1 vote130 views1 answer
Mysql update inner
SQL
1 vote107 views1 answer
Delete mysql from mac
SQL