Adabas SQL Gateway & Dates

, , , , ,
1

Hi, i need to know how to manage the dates using sql gateway

I need to the get the date of the system and substract 3 days back, for example is today is 26/09/2006, then i need a formula to get the date 3 days after, return 23/09/2006

in MSQL i use select dateadd(day,-3,getdate())

how can i do the same in adabas sql gateway??

thanks

2

Please try the following:

   SELECT timestampadd(SQL_TSI_DAY, -3, current_date())

which returns

   9/26/2005

For further information - please refer to the User Reference Guide.