How do I add the time from one field to the date from another?

Question

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Ant-Green SSC Guru Points: 113498 More actions · Answer 1

Something like this

declare @RequestDate datetime = '2015-11-02', @DecisionTime time = '13:29:21.357'

select @RequestDate , @DecisionTime

select

CONVERT(DATETIME,

CONVERT(VARCHAR(10),@RequestDate ,103)

+' '

+CONVERT(VARCHAR(12),@DecisionTime )

)

NineIron SSChampion Points: 12529 More actions · Answer 2

SSChampion

Points: 12529

November 2, 2015 at 6:45 am

Wonderful. Thanx.

Ed Wagner SSC Guru Points: 287026 More actions · Answer 3

If your datetime column already contains a time and you want to add the time from the time column, you could use this approach.

DECLARE @RequestDate datetime = '2015-11-02',

@DecisionTime time = '13:29:21.357';

SELECT @RequestDate, @DecisionTime, @RequestDate + @DecisionTime;

If your second column is also a datetime, it'll add both parts of both columns together correctly.

NineIron SSChampion Points: 12529 More actions · Answer 4

SSChampion

Points: 12529

November 2, 2015 at 6:55 am

Thanx.

Ant-Green SSC Guru Points: 113498 More actions · Answer 5

More than one way to skin a cat and much more slicker, guessing you just get stuck in the ways you have done it in the past.

johnwalker10 SSCrazy Eights Points: 9124 More actions · Answer 6

This worked for me

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

I have tested this in SQL Server 2008.