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 vote184 views1 answer
Delete from IN subquery
SQL
5 votes126 views6 answers
Sql add days to date
SQL
16 votes146 views1 answer
Mysql smallint range
SQL
2 votes133 views1 answer
Mysql Incorrect column specifier for column
SQL
0 vote128 views2 answers
Don't know how to set rpath on your system, if MySQL libraries are not in path mysql2 may not load
SQL
0 vote134 views1 answer
Sql period overlap
SQL
19 votes142 views6 answers
Mysql if null
SQL
1 vote132 views1 answer
Error:Got a packet bigger than 'max_allowed_packet' bytes
SQL
4 votes146 views3 answers
Mysql get column names from table
SQL
23 votes134 views2 answers
Query to delete a database in mysql
SQL