3 Replies Latest reply on Oct 12, 2015 4:26 PM by 2885278

    convert 'Date' to Timestamp

    2885278

      Helo Guys

       

      I have a problem that was confusing me a lot.how to cast Date to Timestamp.

       

      Actually I have a formula like this Timestampadd (SQL_TSI_DAY, 1-DAYOFMONTH(timestamp '@{pvReportDate}{12-23-2015}'), timestamp '@{pvReport}{12-23-2014}') but the result it was not a valid month etc. actually i have tried by cast my presentation variable. for the information I have prompt Report Date as presentation variable which is named @{pvReportDate} as DATE (it was DATETIME but User does not want it so I have to Cast to DATE).

       

      Do I have to convert the PV to timestamp format?How is it?I have tried many time to convert but always show error "Not a valid month","Not correct format" etc.

       

      If you have any suggestion and advises I really appreciate it guys.Thanks a million..I really need your share Guys.