How to add number of days to a date object in oracle?

Question

question

dbkid asked Dec 16, '09

How to add number of days to a date object in oracle?

I am having a requirement that, I need to add 15 days to the joining date.

There is a table called Member. It contains columns Member_Id, Memeber_Name, Join_Date, Validity.

I need to display Validity_Date by adding Validity to Join_Date.

I didn't find any function to do this. Is there any function to add number of days to a date?

Thanks in advance.

oracle

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 1 · 2009-12-16T14:11:18Z

Tariq Rahiman answered Dec 16, '09

CREATE TABLE MEMBER (MEMBER_ID INT, MEMBER_NAME CHAR(10), JOIN_DATE DATE, VALIDITY DATE) go

select to_date(VALIDITY) + interval '15' day from member go

2

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

dbkid commented · Dec 16, 2009 at 02:17 PM

Its very simple and readibility is more. Thanks a lot Tariq Rahiman!

0 ·

BI DWH BALA commented · Dec 16, 2009 at 06:22 PM

I know about Date Object + number of days (Select sysdate+2 from dual). But I don't know the syntax you have given here. This is some thing new to me. Thank you Tariq Rahiman.

0 ·

Answer 2 · 2009-12-16T19:03:06Z

Christian13467 answered Dec 16, '09

Adding days to an oracle date is just adding the amount of days as number.

SELECT sysdate + 10 FROM dual; -- adds 10 days to current datetime SELECT sysdate + 1/1440 FROM dual; -- adds 1 minute to current datetime

The syntax given before is adding a interval. Interval is an oracle type to describe timespans. Look here for more information.

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

question