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

11 votes223 views5 answers
Laravel db facade
SQL
2 votes205 views1 answer
Mysql trigger after update
SQL
3 votes190 views1 answer
Oracle wait
SQL
19 votes196 views6 answers
What is mySQL
SQL
0 vote206 views1 answer
Drop all triggers oracle
SQL
3 votes206 views2 answers
How to start postgresql on windows
SQL
0 vote206 views1 answer
Choose only one for each distinct collumn regardless of other columns
SQL
1 vote231 views1 answer
Homebrew install mysql
SQL
0 vote216 views1 answer
Php select data from mysql database without column name
SQL
1 vote206 views1 answer
How to see logical reads in sql server
SQL