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 vote108 views1 answer
Oracle sql average
SQL
0 vote123 views1 answer
SELECT statement to find the specific cell in database table
SQL
13 votes100 views2 answers
Get tables in database sql
SQL
9 votes96 views3 answers
Mysql get last id
SQL
0 vote120 views1 answer
Check if mysql db is used
SQL
0 vote116 views1 answer
PSQL use LIKE with timestamps
SQL
0 vote101 views1 answer
Duplicate value unique constraint mysql error
SQL
0 vote100 views1 answer
Php mysqli install
SQL
1 vote116 views2 answers
Restart identity cascade
SQL
0 vote101 views1 answer
Data directory postgresql
SQL