current timestamp in sql server inserting record code example

Example: sql server current time without date

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