Time intervals in SAP HANA SQL

[Former Member]

Hi,

Is there instruments in SAP HANA SQL dialect for working with dates and time intervals?

How could I add/subtract interval to date? Something like that:

select (TO_DATE('2040-Jan-10', 'YYYY-MON-DD') - 11::days);

Thanks in advance,

Dmitry.

[Former Member · Accepted solution]

Hi Dmitry,

You maybe can use add_days function, for example ADD_DAYS (TO_DATE ('2040-Jan-10', 'YYYY-MON-DD'), -11).

Regards,

Jerry