How to add 5 days to a date field in Oracle

I have the following statement and I want to add +5 days to ENTRY_DATE column(last column).

select
WO_NUMBER
, CUSTOMER_PO
, CUSTOMER_NAME
, CUSTOMER_CODE
, PBH_CUSTOMER
, CSM
, DEPT_NAME SHOP
, PN
, DESCRIPTION
, ENTRY_DATE WO_CREATION
, STATUS
, DUE_DATE
, MANUAL_ECD ECD
, FIRST_QUOTE_SENT
, LAST_QUOTE_APPROVED
, LAST_QUOTE QUOTE_NUMBER
, LAST_QUOTE_STATUS QUOTE_STATUS
, QUOTED_AMOUNT
, DECODE(WARRANTY_GRANTED,'T','Y','N') WARRANTY_GRANTED
, [b]ENTRY_DATE[/b]
from ba_view_wo_summary
where syscm_auto_key=1 and pbh_customer='N' and status not in ('CLOSED','CANCELLED','CLS INVOICE') and dept_name not like '%GSE%'
order by due_date asc

Open in new window

maximus1974Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Qlemo"Batchelor", Developer and EE Topic AdvisorCommented:
You can indeed just add 5 to the value. You can add " days" to the expression (as text) to make clear what you want to do. So Entry_date+5 and Entry_date + 5 days should work.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
maximus1974Author Commented:
Pardon my ignorance with oracle. the syntax will be:
 
select
WO_NUMBER
, CUSTOMER_PO
, CUSTOMER_NAME
, CUSTOMER_CODE
, PBH_CUSTOMER
, CSM
, DEPT_NAME SHOP
, PN
, DESCRIPTION
, ENTRY_DATE WO_CREATION
, STATUS
, DUE_DATE
, MANUAL_ECD ECD
, FIRST_QUOTE_SENT
, LAST_QUOTE_APPROVED
, LAST_QUOTE QUOTE_NUMBER
, LAST_QUOTE_STATUS QUOTE_STATUS
, QUOTED_AMOUNT
, DECODE(WARRANTY_GRANTED,'T','Y','N') WARRANTY_GRANTED
, ENTRY_DATE+5 AS TARGET_DATE
from ba_view_wo_summary
where syscm_auto_key=1 and pbh_customer='N' and status not in ('CLOSED','CANCELLED','CLS INVOICE') and dept_name not like '%GSE%'
order by due_date asc

Open in new window

0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Query Syntax

From novice to tech pro — start learning today.