8 Replies Latest reply on Mar 25, 2013 4:09 PM by SriniVEERAVALLI

    OBIEE- casting date to char in case functions

      Hi All,

      I am trying to implement this scenario in Oracle Answers:


      I have written something like this in answers:

      CASE WHEN "Dim1".start_date IS NULL THEN 'NA' ELSE "Dim1".start_date END

      I am getting error here since 'NA' is string type. If I do this:

      CASE WHEN "Dim1".start_date IS NULL THEN CAST('NA' AS DATE) ELSE "Dim1".start_date END

      I works fine..but is that correct way to code this scenario?Please help