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

14 votes141 views2 answers
Oracle add attribute to table
SQL
2 votes150 views1 answer
How to delete all duplicate items in mysql
SQL
0 vote143 views1 answer
How to connect to mysql in ef 6
SQL
0 vote139 views1 answer
Postgresql get diff between two dates in Months
SQL
1 vote148 views1 answer
Mysql workbench in ubuntu 14.04
SQL
2 votes123 views1 answer
How to delete columns in sql
SQL
0 vote150 views2 answers
How to get max from each department in sql
SQL
9 votes155 views4 answers
Oracle get table column names
SQL
0 vote164 views1 answer
Mysql grant user wildcard database
SQL
0 vote157 views1 answer
Mysql insert into select transaction c#
SQL