4 Replies Latest reply: Mar 24, 2012 3:59 PM by amigoser RSS

    Format Date with apostrophe

      Hello,

       

      I like to get the max(dateofday) from an existing qvd file and use this date in my SQL against the database to get the missing data up to the current date.

      To query the database (Teradata) I need the SQL where clause like "  where dateofday > '2012-03-15'  ".

      To get the max date from the qvd is no problem, but how can I get the apostrophe around the date value ?

       

      Thanks !

      Amigoser