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

1 vote282 views1 answer
How to truncate a table in databse
SQL
0 vote289 views1 answer
Sql get guid
SQL
-1 vote273 views2 answers
On delete set default sql server
SQL
-3 votes277 views1 answer
Remove spaces sql 2008
SQL
-1 vote291 views1 answer
Count occurrences sql
SQL
6 votes282 views1 answer
Oracle rank() over (partition)
SQL
0 vote305 views1 answer
Exectuer myssql .sql
SQL
0 vote316 views1 answer
Update sql sintax
SQL
0 vote279 views2 answers
Change database postgres
SQL
0 vote343 views1 answer
How to compile a function in oracle
SQL