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

4 votes211 views2 answers
Xampp mysql database server is not starting mac m1
SQL
0 vote213 views3 answers
Sql drop all tables
SQL
4 votes185 views2 answers
Tsql utf to local time
SQL
0 vote203 views1 answer
Implicit inner join table alias
SQL
2 votes225 views2 answers
Python escape string for sql
SQL
0 vote195 views1 answer
Min salary in sql
SQL
0 vote191 views1 answer
How to check which sp is running in sql server
SQL
-1 vote189 views1 answer
Insert results of a stored procedure into a temporary table
SQL
28 votes196 views6 answers
Sql update
SQL
4 votes209 views3 answers
Rename table column postgresql
SQL