sql server current time without date
snippet in sql

sql server current time without date

user978

select CAST(GETDATE() as time(0))