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

20 votes361 views6 answers
Mysql reset auto increment
SQL
0 vote332 views1 answer
Não é possível executar uma operação DML dentro de uma consulta
SQL
0 vote354 views1 answer
Incorrect string value: '\xC4\x81ne' for column
SQL
0 vote337 views1 answer
Procedures sql insert mysql
SQL
1 vote390 views1 answer
Floor function in sql oracle
SQL
8 votes304 views1 answer
Similarities between ddl and dml
SQL
3 votes347 views2 answers
Df to sql pandas sql achemy
SQL
2 votes322 views1 answer
Username sql
SQL
1 vote360 views1 answer
Sql in array query
SQL
1 vote451 views1 answer
Difference between where and having clause
SQL