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 vote158 views1 answer
Check command
SQL
4 votes243 views6 answers
Laravel jwt
SQL
-1 vote142 views3 answers
Update mongodb version ubuntu
SQL
4 votes135 views1 answer
Mysql copy table with new name
SQL
0 vote128 views1 answer
Mysql update sequence with order by
SQL
1 vote152 views1 answer
Sqlite update from another table
SQL
9 votes148 views4 answers
Mysql set id auto increment
SQL
0 vote146 views2 answers
Coursera spark sql max count
SQL
7 votes137 views1 answer
Sql disable safe mode
SQL
0 vote140 views1 answer
Find all tables where column name exists oracle
SQL