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 vote181 views1 answer
Postgresql substring last
SQL
0 vote178 views2 answers
Get all index postgres
SQL
4 votes183 views1 answer
Refresh postgres config
SQL
0 vote183 views1 answer
Object of class mysqli_result could not be converted to string
SQL
14 votes183 views5 answers
Sql oracle limit
SQL
0 vote201 views1 answer
Create table split string function in sql server
SQL
0 vote174 views1 answer
Like sql for second letter of the family name
SQL
0 vote186 views1 answer
Mysql a from on this page has
SQL
1 vote171 views1 answer
Delete mysql from mac
SQL
0 vote269 views8 answers
Sql to c# linq converter online
SQL