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 views3 answers
Sql server obtener fecha en formato dd/mm/yyyy
SQL
-1 vote177 views1 answer
Adding a new table psql
SQL
13 votes159 views2 answers
Mysql order by multiple columns
SQL
0 vote161 views1 answer
How to convert DateTime to VarChar SQL
SQL
0 vote198 views1 answer
Transalations from sql to Linq count and group by
SQL
1 vote181 views1 answer
Oracle insert multiple rows into same table
SQL
0 vote165 views1 answer
Sql select maximum column with other columns returned
SQL
0 vote190 views1 answer
Sql count total by foreign key
SQL
12 votes186 views1 answer
Run mysql instance in docker
SQL
0 vote173 views1 answer
Java nosql sort
SQL