sql server query get time zone code example

Example 1: sql server get utc date

GETUTCDATE()

Example 2: get time component of datetime sql

SELECT convert(varchar(8), getdate(), 108)