Technical Article

Convert DateTime to HH:MM:SS

,

This simple select statemetn will convert a DateTime to HH:MM:SS.

select left(right(convert(char(19),(getdate()),20),8),8) as 'HH:MM:SS'

Rate

You rated this post out of 5. Change rating

Share

Share

Rate

You rated this post out of 5. Change rating