2 Replies Latest reply on Feb 18, 2016 4:34 PM by Marco Ardito

    date add, date diff in teiid?

    Marco Ardito Master

      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