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

8 votes343 views1 answer
How to remove tables from postgresql
SQL
7 votes295 views6 answers
Code: 'er_not_supported_auth_mode', errno: 1251, sqlmessage: 'client does not support authentication protocol requested by server; consider upgrading mysql client', sqlstate: '08004', fatal: true
SQL
6 votes319 views3 answers
Mysql server is not starting xampp
SQL
4 votes383 views6 answers
Select sql
SQL
0 vote360 views1 answer
Connecting mySQL to STS
SQL
1 vote352 views1 answer
Mysql strict_trans_tables
SQL
0 vote359 views2 answers
Sql count number of rows after group by
SQL
0 vote362 views1 answer
Python sql passer des parametres dans une requet pymysql
SQL
0 vote357 views1 answer
Query string starts with vowels
SQL
11 votes341 views1 answer
Oracle insert into where
SQL