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

1 vote347 views1 answer
How to open closed port mysql in ubuntu
SQL
0 vote337 views1 answer
Soql more than today
SQL
0 vote354 views1 answer
Update sqlite
SQL
0 vote332 views1 answer
Check index sql server
SQL
1 vote369 views1 answer
How to test for sql injection
SQL
0 vote334 views1 answer
Mysql xampp reset root password
SQL
0 vote352 views2 answers
Mysql regexp match word
SQL
25 votes408 views1 answer
How to update an attribute in MySQL
SQL
1 vote361 views1 answer
Postgresql pass array in function
SQL
-1 vote359 views1 answer
What is in operator
SQL