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 vote214 views1 answer
Replace string in whole database mysql stackoverflow
SQL
0 vote183 views1 answer
Get records in sql according to month name and count
SQL
0 vote230 views2 answers
Suse Linux restart MySQL
SQL
47 votes298 views6 answers
Add column mysql
SQL
0 vote208 views1 answer
Sql script to remove default from column
SQL
2 votes236 views1 answer
Pandas to sql index
SQL
4 votes192 views1 answer
Sql delete where in select
SQL
1 vote215 views1 answer
Oracle split string
SQL
8 votes212 views2 answers
Oracle undo usage
SQL
13 votes192 views5 answers
Oracle list tables
SQL