Get date for timezone in SQL

Get current date for specific timezone when server is in UTC timezone.

See stack overflow post.

SELECT GETDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'Central Standard Time'