Last post Jul 08, 2016 02:29 PM by kipo
Jul 08, 2016 01:36 PM|skliz4rel|LINK
I have a stored procedure that display or gets current time but it shows with decimal points I suppose they are TimeSpan.
But I want to display just the current time without decimal values.
select CONVERT (time, GETDATE())
I want to display time like 22:00:45 alone. I dont want decimal values.
Jul 08, 2016 02:29 PM|kipo|LINK
Try with this:
select CONVERT(TIME(0), GETDATE())