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 vote336 views1 answer
Postgres get month name from date
SQL
0 vote325 views1 answer
Sql select min row
SQL
1 vote348 views1 answer
Best sql course
SQL
1 vote323 views1 answer
Mysqlworkbench Your connection attempt failed for user 'root' from your host to server at 127.0.0.1:3306: Authentication plugin 'caching_sha2_password' cannot be loaded: dlopen(/usr/local/mysql/lib/plugin/caching_sha2_password.so, 2): image not found
SQL
14 votes344 views1 answer
Oracle alter table add column not null
SQL
1 vote338 views1 answer
Window function mysql
SQL
1 vote342 views1 answer
Mysql get domain from url
SQL
-1 vote312 views2 answers
On delete set default sql server
SQL
1 vote325 views1 answer
Pl sql ptint
SQL
3 votes389 views3 answers
Update con select postgresql
SQL