This discussion is archived
3 Replies Latest reply: Mar 21, 2013 11:46 AM by DonBI RSS

Date to Char conversion is different on two BI servers

DonBI Newbie
Currently Being Moderated
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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points