time_zones

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

Overview

Name	time_zones
Type	Resource
Id	azure.sql.time_zones

Fields

The following fields are returned by SELECT queries:

get

Name	Datatype	Description
id	string	Fully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}.
name	string	The name of the resource.
displayName	string	The time zone display name.
systemData	object	Azure Resource Manager metadata containing createdBy and modifiedBy information.
timeZoneId	string	The time zone id.
type	string	The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts".

list_by_location

Name	Datatype	Description
id	string	Fully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}.
name	string	The name of the resource.
displayName	string	The time zone display name.
systemData	object	Azure Resource Manager metadata containing createdBy and modifiedBy information.
timeZoneId	string	The time zone id.
type	string	The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts".

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
get	select	location_name, time_zone_id, subscription_id		Gets a managed instance time zone.
list_by_location	select	location_name, subscription_id		Gets a list of managed instance time zones by location.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

Name	Datatype	Description
location_name	string	The location of the database. Required.
subscription_id	string
time_zone_id	string	The time zone ID. Required.

SELECT examples

get

Gets a managed instance time zone.

SELECT
id,
name,
displayName,
systemData,
timeZoneId,
type
FROM azure.sql.time_zones
WHERE location_name = '{{ location_name }}' -- required
AND time_zone_id = '{{ time_zone_id }}' -- required
AND subscription_id = '{{ subscription_id }}' -- required
;

list_by_location

Gets a list of managed instance time zones by location.

SELECT
id,
name,
displayName,
systemData,
timeZoneId,
type
FROM azure.sql.time_zones
WHERE location_name = '{{ location_name }}' -- required
AND subscription_id = '{{ subscription_id }}' -- required
;