how to get the timezone in sql server code example

Example: database timezone

the list of database timezone can be found in the link below

https://en.wikipedia.org/wiki/List_of_tz_database_time_zones