date add, date diff in teiid?

[m.ardito]

Hi,

how can I get a calculated date in teiid? eg: if i need to know which day was "yesterday"?

I know mysql syntax like select DATE_ADD(curdate(),INTERVAL -1 day)

or postgresql like SELECT CURRENT_DATE - INTERVAL '1 day'

is there any simple way like those in teiid sql?

docs reference: https://docs.jboss.org/author/display/teiid813final/Date_Time+Functions

Marco

[shawkins]

Teiid uses the JDBC standard function timestampadd:

SELECT timestampadd(SQL_TSI_DAY, -1, curdate())

[m.ardito]

Of course... I've looked at that page, before, but stopped searching at the bottom of the table... sorry to raise this noise...

Thanks,

Marco