Sql Server

Question

Olá pessoal boa noite !

Preciso de uma ajuda , no sql server eu tenho um campo de horas que em instante ele está como 701 e instante 1501 preciso preencher e converter para 07:01 e 15:01 como faço isso ?

Answer 1

Hi @Andre Talon

Please check this:

Declare @table table( FIELD int)
Insert into @table values
(701),(1501)

SELECT STUFF(RIGHT(CONCAT('0000',FIELD),4),3,0,':') AS NewField
FROM @table

Best regards,

Cosmog Hong

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Perfect !
Thanks for the support, simple as that.
I just needed to pad with 0 to the left of the hour and add the :

Answer 3

Your question is not very clear - and I don't think this only due to that Portuguese is a language I don't master very well - but you could try

SELECT dateadd(HOUR, 8, campo)