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 vote163 views2 answers
Postgresql display subquery as json
SQL
0 vote186 views1 answer
Sql auto_increment syntax
SQL
0 vote208 views1 answer
To Create directory
SQL
1 vote189 views1 answer
Mysql backup skip table
SQL
0 vote184 views1 answer
Soql update query
SQL
0 vote193 views1 answer
Vs 2019 connect to local mysql database
SQL
1 vote267 views1 answer
How-can-i-start-postgresql-server-on-mac-os-x
SQL
0 vote221 views2 answers
CREATE OR REPLACE FUNCTION
SQL
1 vote178 views1 answer
How to delete record sql delphi
SQL
0 vote176 views1 answer
1 column values in to 1 single row in sql
SQL