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 vote205 views1 answer
Org.h2.jdbc.jdbcsqlsyntaxerrorexception
SQL
0 vote243 views1 answer
How to set up an anonymous function to variable in swift
SQL
4 votes233 views2 answers
Raise errors.NotSupportedError( mysql.connector.errors.NotSupportedError: Authentication plugin 'caching_sha2_password' is not supported
SQL
0 vote223 views1 answer
Insert array into mysql column
SQL
11 votes219 views1 answer
Get ddl materialized view oracle
SQL
5 votes213 views1 answer
Minecraft java port number
SQL
12 votes229 views5 answers
Rename table in mysql
SQL
6 votes214 views4 answers
Remove spaces sql server
SQL
0 vote219 views1 answer
Sql show all users
SQL
1 vote222 views1 answer
List all triggers in SQL Server
SQL