Add Day to Timestamp

sql oracle timestamp date-arithmetic
Nadir picture Nadir · May 26, 2011 · Viewed 50.1k times · Source

How do I add days to a timestamp? If my timestamp is 01-JAN-2011 11-09-05 and I add 2 days, I want 03-JAN-2011 11-09-05.

Answer

Marc B picture Marc B · May 26, 2011 
select '01-jan-2011 11-09-05' + interval '2' day

Related questions

ORA-01810: format code appears twice

Why is the sql below generating an ORA-01810 error? I researched the error and I am using different date formats for each date insert INSERT INTO bag_grte_clm ( schd_dprt_ldt, arr_trpn_stn_cd, bkg_crtn_gdt, sbmt_…

Read More
Convert milliseconds to Timestamp

I know that to convert a Unix timestamp in milliseconds to an SQL timestamp I can use SELECT TO_DATE('1970-01-01','YYYY-MM-DD HH24:MI:SS') + (:timestamp / (1000*60*60*24)) FROM DUAL; But I need a Timestamp, so I tried with …

Read More
PL SQL - Convert timestamp to datetime/date

select to_timestamp(SCHEDULED_TIME,'YYYY-MM-DD HH24:MI:SS.FF') as SCHEDULED_TIME, TRUNC(to_date(to_timestamp(SCHEDULED_TIME,'YYYY-MM-DD HH24:MI:SS.FF'),'YYYY-MM-DD HH24:MI:SS')) from S_TIDAL_STATUS The error was: ORA-01830: date format picture …

Read More