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

31 votes126 views3 answers
Sql count
SQL
6 votes113 views5 answers
Mysql get last insert id
SQL
1 vote112 views1 answer
Create procedure with encryption
SQL
0 vote157 views1 answer
SQL-Arten
SQL
16 votes121 views1 answer
Mssql int max value
SQL
1 vote109 views1 answer
Sql server 2012 query history
SQL
0 vote201 views1 answer
Run mysql xampp shell
SQL
0 vote112 views1 answer
Execut sql python
SQL
0 vote181 views1 answer
Mariadb date equals to current_date plus days
SQL
0 vote121 views1 answer
Get record which is available in one table but not in another mysql
SQL