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 vote362 views3 answers
Sql all columns
SQL
5 votes351 views1 answer
Oracle columns in all_tables
SQL
-1 vote346 views1 answer
Mysql extract days
SQL
0 vote340 views1 answer
Go install mysql
SQL
1 vote346 views1 answer
Python escape string for sql
SQL
11 votes354 views4 answers
Query DISTINCT
SQL
0 vote373 views1 answer
SQL Where-Klausel
SQL
0 vote349 views1 answer
Where case insensitive like mysql
SQL
0 vote348 views1 answer
T-sql check if data exists
SQL
5 votes353 views1 answer
Oracle ORA-00054 origin
SQL