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 vote225 views1 answer
Mysql add comment to column
SQL
1 vote229 views2 answers
Mysql show views
SQL
-1 vote227 views1 answer
Mysql extract days
SQL
0 vote236 views1 answer
Install sql server in ubuntu 20.04
SQL
0 vote269 views1 answer
Delete from table where length sql
SQL
0 vote213 views1 answer
MySQLdb._exceptions.ProgrammingError: (1146, "Table 'edxapp.app_feedback feedback category' doesn't exist")
SQL
0 vote229 views1 answer
Data structures in sql
SQL
0 vote226 views1 answer
Sql waitfor
SQL
2 votes257 views3 answers
Row number mysql
SQL
0 vote232 views1 answer
Tsql pad left
SQL