Equalent to DATEADD in Datastage

[SURA]

Hello All

I had a situation where i need to convert from UTC Time to Local Time. In SQL Server i found a function called DATEADD. This function will returns a new datetime value based on adding an interval to the specified date.

Is there is any function can we use in Datastage to achive the same task?

Thanks in advance.
DS User

[prakashdasika]

DateFromDaysSince() for dates. TimestampFromSecondsSince() for timestamp.

[djbarham]

DATEADD. This function will returns a new datetime value based on adding an interval to the specified date.

Is there is any function can we use in Datastage to achive the same task?

Have a look at TimestampOffsetByComponents

[BI-RMA]

Have a look at TimestampOffsetByComponents

The Offset-functions are new in 8.5! Not so often mentioned as goodies but much easier to handle than the alternatives from former versions (which are still present)!