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 vote263 views1 answer
Oracle select first row order by
SQL
1 vote227 views1 answer
Sql server find tables referenced foreign key
SQL
1 vote272 views1 answer
Concat first name and last name in mysql
SQL
5 votes232 views2 answers
Postgre insert select
SQL
0 vote263 views1 answer
Pl sql disable trigger
SQL
34 votes247 views5 answers
Oracle alter table add column
SQL
0 vote243 views1 answer
Mysql root localhost run
SQL
6 votes222 views1 answer
Rank function in oracle with example
SQL
6 votes215 views1 answer
Oracle trigger after connect
SQL
1 vote248 views3 answers
Drop unique key constraint in sql server
SQL