这对我很有效

CAST(Tbl.date as DATETIME) + CAST(Tbl.TimeFrom AS TIME)

(适用于SQL 2008 R2)

我遇到了类似的情况，我必须将日期和时间字段合并到DateTime字段。上面提到的解决方案都不行，特别是添加两个字段作为添加这两个字段的数据类型是不一样的。

我创建了下面的解决方案，其中我添加了小时和分钟部分的日期。这对我来说非常有效。请查看一下，如果遇到任何问题请告诉我。

与资源; 作为 （ select StatusTime = '12/30/1899 5:17:00 PM'， StatusDate = '7/24/2019 12:00:00 AM' ) select DATEADD(MI, DATEPART(MINUTE,CAST(tbl))StatusTime AS TIME))，DATEADD(HH, DATEPART(小时，CAST(tbl))。StatusTime AS TIME))， CAST(tbl。StatusDate为DATETIME)) 从台

执行结果:2019-07-24 17:17:00.000

结合日期从一个datetime列和时间从另一个datetime列，这是最好的，最快的解决方案为您:

select cast(cast(DateColumn as date) as datetime) + cast(TimeColumn as datetime) from YourTable

DECLARE @Dates table ([Date] datetime);
DECLARE @Times table ([Time] datetime);

INSERT INTO @Dates VALUES('2009-03-12 00:00:00.000');
INSERT INTO @Dates VALUES('2009-03-26 00:00:00.000');
INSERT INTO @Dates VALUES('2009-03-30 00:00:00.000');

INSERT INTO @Times VALUES('1899-12-30 12:30:00.000');
INSERT INTO @Times VALUES('1899-12-30 10:00:00.000');
INSERT INTO @Times VALUES('1899-12-30 10:00:00.000');

WITH Dates (ID, [Date])
AS (
    SELECT ROW_NUMBER() OVER (ORDER BY [Date]), [Date] FROM @Dates
), Times (ID, [Time])
AS (
    SELECT ROW_NUMBER() OVER (ORDER BY [Time]), [Time] FROM @Times
)
SELECT Dates.[Date] + Times.[Time] FROM Dates
    JOIN Times ON Times.ID = Dates.ID

打印:

2009-03-12 10:00:00.000
2009-03-26 10:00:00.000
2009-03-30 12:30:00.000

如上所述，我有很多错误，所以我这样做

try_parse(concat(convert(date,Arrival_date),' ',arrival_time) as datetime) AS ArrivalDateTime

这对我很管用。

SELECT (CAST(@TimeField As Date) As DateTime) + CAST(CAST(@TimeField As Time) As DateTime)