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 vote276 views1 answer
ALL_TAB_PARTITIONS
SQL
1 vote272 views1 answer
PLS-00225 type
SQL
2 votes267 views1 answer
Import large .sql files into lampp
SQL
0 vote285 views1 answer
WHERE not regex in SQL
SQL
1 vote265 views1 answer
Error code 1055
SQL
1 vote279 views1 answer
Oracle repeat_interval 5 minutes
SQL
1 vote263 views1 answer
Get url of cpanel database hostname
SQL
2 votes274 views1 answer
Oracle current date without time
SQL
3 votes263 views2 answers
Funktion LOWER/UPPER sql
SQL
0 vote278 views1 answer
Null column as zero in mysql
SQL