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

4 votes328 views6 answers
Sql select statement
SQL
0 vote325 views1 answer
Mysql make date from 2 column
SQL
6 votes318 views4 answers
Delete table sqlite
SQL
6 votes308 views1 answer
Oracle desc table primary key
SQL
0 vote305 views1 answer
How to save data in database in mysql node
SQL
5 votes327 views3 answers
MySql get fields of table
SQL
0 vote308 views1 answer
Sql query to check if column contains alphabets
SQL
0 vote302 views1 answer
Delete double on SQL with multiple primary keys
SQL
0 vote318 views1 answer
Can't connect to postgresql mac os
SQL
7 votes306 views2 answers
N highest salary in sql
SQL