DATE function in OLEDB SQL Query

[Former Member]

Hi All,

I have to add date to a date field using OLEDB SQl Query.

But I could not find  any ADD Date fuction for this which is supported by OLEDB Connector.

example:

I have to use similar function in OLEDB QUERY as given below SQL Query:

Select ADDDATE('day', DateTime, 1) as NextDay

from TableName

Please let me know how to use adddate in OLEDB SQL Query.

Thanks & Regards

manisha

[HariCS23]

Hi Manisha, What is your ODBC source system??

try

select Datetime + 1

Date("tomarrow") .. ( i Know there are Date("today") and Date("yesterday") functions exists in PI OLEDB ..so hopefully Date("tomarrow) too. )

But its better to refer the documentation provided by your source system .

Thanks

Hari