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 vote204 views1 answer
Get only structure database mysql
SQL
0 vote183 views1 answer
Mysql zerofill
SQL
2 votes170 views1 answer
Alter table add column and foreign key mysql
SQL
1 vote181 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
1 vote179 views1 answer
Pl sql insert into table
SQL
0 vote175 views1 answer
Order by with where clause in mysql
SQL
1 vote179 views1 answer
Host 127.0 0.1 is not allowed to connect to this mysql server
SQL
11 votes171 views2 answers
Mysql set safe mode off
SQL
0 vote184 views1 answer
Sql where time stamp is in between
SQL
0 vote191 views1 answer
Executescalar in sql server
SQL