SQL Server 2012 SP1 return incorrect date result, UK region - by Elvis Long

Status : 


Sign in
to vote
ID 800846 Comments
Status Active Workarounds
Type Bug Repros 0
Opened 9/15/2013 10:04:38 PM
Access Restriction Public


I use SQL 2005, 2008, 2008R2 to run the query above: 
WITH MEMBER  [LinkTimeAdd11Date_Manual] as dateadd("d",15,"11/12/1998")
MEMBER [LinkTimeAdd15Date_Manual] as dateadd("d",15,"13/12/1998")
SELECT { [LinkTimeAdd11Date_Manual] ,[LinkTimeAdd15Date_Manual]} ON COLUMNS
FROM [Adventure Works] 

It will return the following result what I want: 
LinkTimeAdd11Date_Manual    LinkTimeAdd15Date_Manual
12/26/1998                             12/28/1998

However, if I run the same MDX query on SQL Server 2012 SP1, I always get the following result: 
LinkTimeAdd11Date_Manual    LinkTimeAdd15Date_Manual
11/27/1998                          12/28/1998

Note: The regoin and language settings are set to "United Kingdom" for all of SQL Servers. 
I tried to change the regoin and lanauge, but didn't work. 
Sign in to post a comment.
Posted by Jackanory on 3/28/2014 at 3:20 PM
This is only happening recently for me
Posted by skeezwiz1 on 3/6/2014 at 9:38 PM
I have noticed dates are compared and handled differently in ssas 2012 vs ssas 2008, and giving different results in MDX.
We switched back from this driver to SQLOLEDB.1 and results are correct, msft needs to confirm and fix.