adding hh:mm:ss time to yyyy-mm-dd hh:mm:ss format

Question

Post reply

adding hh:mm:ss time to yyyy-mm-dd hh:mm:ss format

Viewing 3 posts - 16 through 17 (of 17 total)

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

Steve Jones - SSC Editor SSC Guru Points: 736212 More actions · Answer 1

You also can use DateTimeFromParts()

https://docs.microsoft.com/en-us/sql/t-sql/functions/datetimefromparts-transact-sql?view=sql-server-ver15

Jeffrey Williams SSC Guru Points: 90303 More actions · Answer 2

DaveBriCam wrote:

The ConvoHrs table is coming from a vendor we have no control over.

How is the vendor providing that data? Is this through a linked server - a file that is imported, something else? What is the format of the event_sec data and are you 100% positive it will always be in that format? The same with created_at - 100% sure it will always be provided in the exact same format every time?

Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

― Charles R. Swindoll

How to post questions to get better answers faster
Managing Transaction Logs

Steve Jones - SSC Editor SSC Guru Points: 736212 More actions · Answer 3

Sorry, didn't quite read the entire thread. You could do some manipulation with datetimefromparts, but the easiest way might be this:

declare @dt datetime  = getdate()
, @time time = '1:00'

select @dt + cast(@time as datetime)