How to Add Day to Date Prompt in Pass Through SQL??

Database
Enthusiast

How to Add Day to Date Prompt in Pass Through SQL??

Hi all,

I am building a SQL in which I have a date prompt.

My back end is Oracle and the column I am using has datatype of DATE. Below is the condition I am using.

Where BGN_DATE <= #sq(prompt('ToDate', 'date'))#

It is working but I have to add 30 days to 'ToDate'. Is it possible? How can I do this? Is there any function I can use?

Gurus, your help is required in this.

Thanks in advance.

Tags (1)
1 REPLY
Junior Contributor

Re: How to Add Day to Date Prompt in Pass Through SQL??

I don't know how the prompted date is passed to the query, but adding days in Teradata is just adding numbers:

 #sq(prompt('ToDate', 'date'))# + 30

Dieter