mycoolross — Wed, 17 Apr 2002 04:20:46 +0000

Thanks Peter!

I ended checking the length of the
variable and using an STR() function then
concatenating.

I could post the code tomorrow if you would like to see it.

Thanks,

Mike

Peter J. Boettcher — Wed, 17 Apr 2002 02:38:29 +0000

Check the date/time format on the server, I'm pretty sure SQL takes its settings from there, you might be able to force the 0.

If not just add the following line after every calculation:

Set @Hour=CAST(@Hour AS Char(2))
If Len(@Hour) = 1 Set @Hour = '0' + @Hour

Repeat for minutes and seconds. Not pretty but it should do the trick.