CODE EXAMPLE FOR SQL

sql server current time without date

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