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 vote149 views1 answer
Sql add calculated column
SQL
5 votes151 views2 answers
Ranking functions in sql
SQL
0 vote157 views1 answer
Query string starts with vowels
SQL
0 vote139 views1 answer
Oracle last user logon
SQL
79 votes357 views6 answers
Grepper code
SQL
1 vote170 views1 answer
Oracle activate job
SQL
1 vote141 views2 answers
Oracle difference between two dates in seconds
SQL
4 votes978 views2 answers
Host '192.168.43.100' is not allowed to connect to this MySQL server
SQL
2 votes184 views1 answer
Mysql now format
SQL
5 votes151 views3 answers
Truncate function in sql oracle
SQL