3 Replies Latest reply: Mar 21, 2013 2:04 PM by Srini VEERAVALLI RSS

    Date to Char conversion is different on two BI servers

    DonBI
      I have Test and Prod environments for BI. I am getting two different results when I convert the date column to character. What could be the issue?.


      I go to BI presentation services and issue sql.

      ============================

      Test:

      Select cast("Emp.End Date" as char)
      from "Employees"

      I get below results.

      2011/10/15 00:00:00

      ============================
      ============================

      Production:

      Select cast("Emp.End Date" as char)
      from "Employees"

      I get below results.

      15-OCT-11

      ============================

      I checkd both the rpd's. Data type is DATE in both the cases. There are no date format execution scripts in connection pools.

      Can somebody please explain where to fix the issue? I want to see DD-MON-YY format when I cast to character.