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

2 votes135 views2 answers
TSQL GET ALL COLUMNS IN TABLE
SQL
0 vote180 views1 answer
Contraint default SQL
SQL
1 vote118 views1 answer
How to delete data from sql database in android
SQL
1 vote158 views4 answers
How to check table in postgresql from terminal
SQL
0 vote132 views1 answer
Split string by comma in sql server
SQL
0 vote132 views2 answers
Psql commande \gset
SQL
11 votes152 views3 answers
Sql line numbers
SQL
0 vote129 views1 answer
Sqlcmd no headers
SQL
1 vote145 views1 answer
Sqlite3 read only
SQL
0 vote162 views2 answers
Suse stop MySQL
SQL