Home Dashboard Directory Help
Search

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


Status: 

Active


2
0
Sign in
to vote
Type: Bug
ID: 800846
Opened: 9/15/2013 10:04:38 PM
Access Restriction: Public
0
Workaround(s)
view
0
User(s) can reproduce this bug

Description

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.
Details
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.
Sign in to post a workaround.