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 vote293 views1 answer
Mariadb change column type
SQL
0 vote257 views1 answer
Drop all tables in azure sql database
SQL
1 vote276 views1 answer
Wordpress change http to https phpmyadmin
SQL
1 vote266 views1 answer
Postgresql contains
SQL
2 votes259 views2 answers
Compare date mysql
SQL
0 vote282 views1 answer
Tinydb add table
SQL
1 vote272 views1 answer
Mysql return if it contains
SQL
0 vote258 views1 answer
Mysql shell set time_zone
SQL
1 vote278 views1 answer
Oracle enable job
SQL
0 vote265 views1 answer
Mysql update even / odd rows
SQL