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

2 votes151 views1 answer
Find column in all stored procedures sql server
SQL
23 votes132 views6 answers
Create table sql server
SQL
1 vote132 views1 answer
Get create table query existing table mysql
SQL
5 votes122 views2 answers
Copy data from one database to another
SQL
1 vote128 views1 answer
Timestamp in sqlite
SQL
0 vote125 views1 answer
Codeigniter MySQL - Issue with SELECT & GROUP BY
SQL
3 votes114 views1 answer
Mysql CURRENT_TIMESTAMP()
SQL
0 vote186 views1 answer
1422: Explicit or implicit commit is not allowed in stored function or trigger
SQL
0 vote121 views2 answers
Csv into data postgres
SQL
1 vote135 views1 answer
How to show index type in postgresql
SQL