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 vote130 views1 answer
Clear query cache sql server
SQL
0 vote149 views1 answer
Mysql pad zeros
SQL
1 vote159 views1 answer
Delete dublicate rows sql
SQL
4 votes144 views2 answers
Oracle set date format
SQL
0 vote140 views1 answer
Postpresql relation not found
SQL
-1 vote135 views1 answer
How to use update trigger in sql
SQL
0 vote137 views1 answer
Get the Domain Name, Page Name and Query Parameter from a URL
SQL
25 votes147 views5 answers
Date in mysql
SQL
0 vote160 views1 answer
Hallo
SQL
14 votes220 views1 answer
How to export db from mysql
SQL