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 vote268 views1 answer
How to drop columns with constraint from a table in sql script
SQL
0 vote327 views1 answer
Oracle chain step succeeded
SQL
0 vote290 views4 answers
Mysql on kubernetes
SQL
0 vote299 views1 answer
Foreign key type uniqu mysql
SQL
0 vote276 views1 answer
Min salary in sql
SQL
0 vote282 views1 answer
Mysql order by where condition sub query
SQL
1 vote319 views2 answers
Intersect sql
SQL
0 vote314 views1 answer
Mysql change default collation
SQL
0 vote277 views2 answers
MySQL top percent
SQL
0 vote271 views1 answer
Wordpress sql change site url
SQL