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 vote277 views1 answer
Data structures in sql
SQL
0 vote292 views1 answer
Drop index in sql
SQL
1 vote290 views1 answer
How to lock table in mysql
SQL
0 vote288 views1 answer
Delete first row in sql
SQL
2 votes268 views2 answers
Mysql get time from datetime
SQL
1 vote262 views1 answer
How to see all table partition in oracle
SQL
1 vote234 views1 answer
Postgres division by zero
SQL
0 vote280 views1 answer
How to drop a trigger in postgresql
SQL
1 vote269 views1 answer
Mysql limit results to 10
SQL
2 votes294 views1 answer
Merge firstname and lastname in sql oracle
SQL