sql server current time without date code example

Example: sql server current time without date

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