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 vote118 views1 answer
Format the money fied with comma in international system using sql
SQL
0 vote135 views1 answer
Mysql default tls v1.3 ciphersuites
SQL
0 vote123 views1 answer
Which sql statement would you use to remove a view called emp_dept_vu from your schema?
SQL
0 vote118 views1 answer
Mysql workbench indent formatting
SQL
0 vote122 views1 answer
Oracle current timestamp insert statement
SQL
0 vote108 views1 answer
Install mysql 8 linux
SQL
0 vote127 views1 answer
Get last date join sql
SQL
2 votes120 views1 answer
Enum in SQL Server
SQL
0 vote127 views1 answer
Php get closest location by latitude longitude
SQL
0 vote109 views1 answer
Mysql update sequence with order by
SQL