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 votes289 views1 answer
Install sqlite npm
SQL
0 vote288 views1 answer
Mysql update sum same table
SQL
0 vote311 views1 answer
Oracle archivelog usage
SQL
0 vote321 views2 answers
Sql query inner join 3 tables
SQL
27 votes312 views6 answers
Set password mysql
SQL
21 votes323 views1 answer
SQL cheat sheet pdf
SQL
0 vote348 views1 answer
Mysql, how to query the table comments?
SQL
0 vote299 views1 answer
Creation d'un trigger sql
SQL
2 votes310 views1 answer
How to get weekday from old date in sql
SQL
0 vote340 views1 answer
Pgadmin save data greyed out
SQL