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 vote159 views1 answer
Call object contructor and call methods of object
SQL
0 vote163 views3 answers
Condition in count sql
SQL
0 vote159 views1 answer
Mysql Selected All Duplicate Rows
SQL
1 vote151 views2 answers
Install mysqldump ubuntu
SQL
0 vote170 views1 answer
Shows all databases created by user in ms sql
SQL
0 vote146 views1 answer
Postgresql newline character
SQL
3 votes147 views1 answer
Oracle revoke grant
SQL
1 vote230 views1 answer
Sql server delete top 1000
SQL
0 vote146 views1 answer
Postgresql find missing id
SQL
1 vote291 views1 answer
Import sql file from laravel
SQL