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

Share

Share

Rate