Converting a smallint to time

Question

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

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

philcart SSC-Forever Points: 47797 More actions · Answer 1

Try this

declare @sec smallint

set @sec = 133

select convert(varchar(8), dateadd(second,@sec,0), 114) as WithHour

select right(convert(varchar(8), dateadd(second,@sec,0), 114), 5) as WithoutHour

--------------------
Colt 45 - the original point and click interface

SwePeso SSC-Dedicated Points: 39757 More actions · Answer 2

Keep it simple. Why use 114 (with milliseconds when source data is not?

SELECT CONVERT(VARCHAR, @Sec, 108)

N 56°04'39.16"
E 12°55'05.25"

philcart SSC-Forever Points: 47797 More actions · Answer 3

Ah yes forgot about style 108, thanks Peter.

--------------------
Colt 45 - the original point and click interface

Brian Pastre SSC-Addicted Points: 494 More actions · Answer 4

Thanks for your quick replies. I tried both. Phil's gave me the results I was looking for, but but Peter's did not. Not sure why.

Thanks again!

philcart SSC-Forever Points: 47797 More actions · Answer 5

Peter's response was just on my time conversion. So in my solution you can use style 108 instead of 114.

eg:

select convert(varchar(8), dateadd(second,@sec,0), 108) as WithHour

select right(convert(varchar(8), dateadd(second,@sec,0), 108), 5) as WithoutHour

--------------------
Colt 45 - the original point and click interface

Cookies on SQLServerCentral