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