time_zones

Creates, updates, deletes, gets or lists a time_zones resource.

Overview

Name	time_zones
Type	Resource
Id	azure.sql.time_zones

Fields

vw_time_zones

Name	Datatype	Description
display_name	text	field from the properties object
locationName	text	field from the properties object
subscriptionId	text	field from the properties object
timeZoneId	text	field from the properties object
time_zone_id	text	field from the properties object

time_zones

Name	Datatype	Description
properties	object	The properties of a time zone.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	locationName, subscriptionId, timeZoneId	Gets a managed instance time zone.
list_by_location	SELECT	locationName, subscriptionId	Gets a list of managed instance time zones by location.

SELECT examples

Gets a list of managed instance time zones by location.

vw_time_zones

SELECT
display_name,
locationName,
subscriptionId,
timeZoneId,
time_zone_id
FROM azure.sql.vw_time_zones
WHERE locationName = '{{ locationName }}'
AND subscriptionId = '{{ subscriptionId }}';

time_zones

SELECT
properties
FROM azure.sql.time_zones
WHERE locationName = '{{ locationName }}'
AND subscriptionId = '{{ subscriptionId }}';