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 vote148 views1 answer
Create another table from existing table sql oracle
SQL
0 vote169 views1 answer
Delete ids between sql
SQL
0 vote179 views1 answer
Query to insert image
SQL
0 vote171 views1 answer
Show all sequences postgres
SQL
0 vote150 views1 answer
Sql server select value large text
SQL
0 vote151 views2 answers
How to save result of sqlite query in a table
SQL
-1 vote148 views3 answers
Error mysql shutdown unexpectedly
SQL
11 votes158 views1 answer
Creating tables in sql with python
SQL
12 votes161 views1 answer
Psql drop column
SQL
1 vote166 views1 answer
Mysql order by desc null last
SQL