Search

From Remote query(linked server) we can't concatenate date and time data types by Naach

Closed
as Won't Fix Help for as Won't Fix

1
1
Sign in
 to vote
Type: Bug
ID: 772207
Opened: 11/26/2012 3:52:21 AM
Access Restriction: Public
0
Workaround(s)
0
User(s) can reproduce this bug
Hi,
Today I have come across very strange bug in SQL Server 2012 SP1 that we can't able to concatenate date and time data types if it remote query but same SQL statement can work fine locally.


Thanks
Nachi
Details (expand)

Product Language

English

Version

SQL Server 2012 - Enterprise Edition

Category

SQL Engine

Operating System

Windows Server 2008 R2 Enterprise

Operating System Language

US English

Steps to Reproduce

For example if we are querying remote query the following don't work:

select CAST(ArrivalDate as Date)+CAST(ArrivalTime AS Time)
from TestTable

but same query work fine locally.

Work around is :
select CAST(ArrivalDate as DateTime)+CAST(ArrivalTime AS Time)
from TestTable

This is defenitely a bug in SQL Server 2012 please fix it.

Actual Results

Work around is :
select CAST(ArrivalDate as DateTime)+CAST(ArrivalTime AS Time)
from TestTable

Expected Results

Work around is :
select CAST(ArrivalDate as DateTime)+CAST(ArrivalTime AS Time)
from TestTable

Platform

X64

Virtualization

 
File Attachments
0 attachments
Sign in to post a comment.
Posted by Microsoft on 2/26/2013 at 7:28 PM
Hi, Thank you for your feedback. As there is a workaround, we have no plans to fix it at this time. With the given resources and schedule, we will look into issues that don't have feasible workarounds. Thanks & Regards, Pooja Harjani, Progam Manager
Sign in to post a workaround.
© 2013 Microsoft Corporation. All rights reserved. Microsoft Connect Terms of Use | Trademarks | Privacy Statement