5 Replies Latest reply: Apr 24, 2013 1:06 PM by 867823 RSS

    obiee 11g upgrade issue for date format

    867823
      Hi,

      I am facing a date format issue with obiee 11g report. This statement cast(cast(current_date as char) as timestamp) is failing with "not a valid month" error in obiee 11g. This worked fine with obiee 10g.

      I am basically trying to set the date to 12:00:00 am of the sysdate. Below is what I am trying to achieve:

      timestampadd(sql_tsi_hour, 1, cast(cast(current_date as char) as timestamp)))

      the above statement fails in obiee 11g.

      Thanks for your help,
      AP