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 vote309 views1 answer
Hangfire clear all jobs
SQL
13 votes251 views5 answers
Select last row mysql
SQL
0 vote218 views1 answer
'0000-00-00' for column '
SQL
2 votes291 views3 answers
Xampp mysql database not starting
SQL
-1 vote269 views1 answer
Mysql select count if contains
SQL
0 vote263 views1 answer
Sql delete row from table where id
SQL
0 vote251 views2 answers
Mysql password error create datbase
SQL
0 vote250 views1 answer
Nth max in my sql
SQL
0 vote265 views1 answer
Google sheets data validation custom formula filter
SQL
10 votes271 views4 answers
Primary key in sql
SQL