format column

Question

Hi,

I have a numeric column that is representing seconds.

How can I format these values in an sql statement to a string format 'HH:mm:ss'?

Best regards,

Stijn.

Answer 1

Hi Stijn,

Please try:

DECLARE @S INT
SET @S=80
SELECT CONVERT(VARCHAR(8),DATEADD(s,@S,0),108) 

TechNet Subscriber Support
If you are TechNet Subscription user and have any feedback on our support quality, please send your feedback here.

---

Stephanie Lv

TechNet Community Support