Breaking News: Grepper is joining You.com. Read the official announcement!

oracle sql timestamp

Aryman answered on May 8, 2021 Popularity 9/10 Helpfulness 5/10

answer oracle sql timestamp

related oracle current timestamp

oracle sql timestamp

Comment

to_timestamp('2022-03-12 21:24:00', 'yyyy-mm-dd hh24:mi:ss')
to_date('2022-03-12 21:24:00', 'yyyy-mm-dd hh24:mi:ss')

Popularity 9/10 Helpfulness 5/10 Language sql

Source: stackoverflow.com

Tags: oracle sql sql-timestamp

Link to this answer
Share Copy Link

Contributed on Mar 09 2022

Aryman

0 Answers Avg Quality 2/10

Closely Related Answers

oracle current timestamp

Comment

-- 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

Popularity 10/10 Helpfulness 9/10 Language sql

Source: stackoverflow.com

Tags: date

Link to this answer
Share Copy Link