5 Replies Latest reply on Apr 24, 2013 6:06 PM by 867823

    obiee 11g upgrade issue for date format


      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,