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 vote170 views1 answer
Postgres jsonb array push new element
SQL
0 vote169 views1 answer
Set a default value for a column in sqlite
SQL
0 vote193 views2 answers
Sql having multiple conditions
SQL
0 vote155 views1 answer
Oracle index hint multiple tables example
SQL
0 vote192 views1 answer
Postgresql like
SQL
0 vote160 views1 answer
Stop psql server windows
SQL
3 votes189 views1 answer
Sql add two values together
SQL
2 votes185 views3 answers
How do I add a user to a postgres database? cli
SQL
6 votes184 views3 answers
Mysql create database utf8
SQL
3 votes166 views3 answers
Create table in microsoft sql server
SQL