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 vote107 views1 answer
Postgres meta command to show all rows in table
SQL
10 votes114 views2 answers
Forgot my mysql password mac
SQL
0 vote107 views1 answer
Mariadb search columns
SQL
5 votes108 views2 answers
Oracle tables with column name
SQL
1 vote91 views1 answer
Update mysql centos
SQL
1 vote99 views1 answer
Mysql server does not start mac
SQL
0 vote114 views1 answer
Character count sql
SQL
0 vote103 views2 answers
Azure sql-datenbank
SQL
2 votes116 views1 answer
Merge firstname and lastname in sql oracle
SQL
1 vote121 views2 answers
Sql queries practice
SQL