How to Extract Time from Date?

Select Getdate() as 'Current Date', RIGHT(CONVERT(VARCHAR, GETDATE(), 100),7) as Time




Select current_timestamp as 'Current Date',RIGHT(CONVERT(VARCHAR, current_timestamp, 100),7) as Time