SQL Server Forums - Convert Number in HH:mm:ss

Home | Weblogs | Forums | SQL Server Links

SQL Server Forums

Register Now and get your question answered!

All Forums

Convert Number in HH:mm:ss

New Topic

Author

Topic

giannilionetti
Starting Member

3 Posts

Posted - 01/17/2013 : 05:41:55

I need to Convert a number without decimal in HH:mm:ss

James K
Flowing Fount of Yak Knowledge

1744 Posts

Posted - 01/17/2013 : 05:52:58

What is content of the number? is it YYYYMMDDHHmmss or HHmmss or something else? Post some sample data?

visakh16
Very Important crosS Applying yaK Herder

India
48090 Posts

Posted - 01/17/2013 : 05:53:58

just do like example below provided number represents seconds


DECLARE @Number int
SET @Number=234
SELECT CONVERT(varchar(8),DATEADD(ss,@Number,0),108)

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

visakh16
Very Important crosS Applying yaK Herder

India
48090 Posts

Posted - 01/17/2013 : 05:57:23

also see

http://visakhm.blogspot.in/2010/03/time-difference-function.html

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

madhivanan
Premature Yak Congratulator

India
22469 Posts

Posted - 01/17/2013 : 06:05:10

In 2012, you can also do

select format(getdate(),'hh:mm:ss')

Madhivanan

Failing to plan is Planning to fail

Topic

New Topic

Jump To:

SQL Server Forums

This page was generated in 0.06 seconds.