Hi
I know this is not a complicated matter.
I'm using this code in my SP to return the time formated in 24 hours
DECLARE @.Hora VARCHAR(5)
SET @.Hora = CONVERT(char(2), DatePart (hh,GetDate())) + ':' + CONVERT(char(2), DatePart (mi,GetDate()))
print @.Hora
te problem is that when the time is any before 10 am for instance 7:23 am the sp returns 7 :23 and I need it ro return 07:23.
What function allows me to insert that '0' to complete the 5 digits format in this case?
thanks
Try this instead:
SELECT My24HrTime = convert( char(5), getdate(), 114 )
For future reference, you may wish to refer to the 'style' chart in Books Online, Topic: 'Cast and Convert'.
(The number 114, above is the 'style' used in the convert() function.)
No comments:
Post a Comment