Azure環境のSQLServerの時間について

Hello Yamauchi,Daisuke/山内 大介

Azure SQL Database does not support changing the default time zone, which is always set to UTC. However, you can convert the time to your desired time zone using the AT TIME ZONE function.

Converts an inputdate to the corresponding datetimeoffset value in the target time zone. When inputdate is provided without offset information, the function applies the offset of the time zone assuming that inputdate is in the target time zone. If inputdate is provided as a datetimeoffset value, then AT TIME ZONE clause converts it into the target time zone using the time zone conversion rules.

Refer: https://learn.microsoft.com/en-us/sql/t-sql/queries/at-time-zone-transact-sql?view=sql-server-ver17

UTC:

SELECT GETDATE() AT TIME ZONE 'UTC'

Local TimeZone:

SELECT GETDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'Japan Standard Time' AS LocalTime;

You can also make a User Defined Function (UDF) to convert UTC to your local time.

This can make it easier to use the conversion in multiple places in your database.

CREATE FUNCTION dbo.ConvertToLocalTimeEightHour (@utcTime DATETIME)
RETURNS DATETIME
AS
BEGIN
    RETURN DATEADD(HOUR, 9, @utcTime); -- Adjust 9 hours for UTC+9
END;
GO
-- Usage
SELECT dbo.ConvertToLocalTimeNineHour (GETDATE()) AS LocalTime;

Hope this should help in your case.

Let us know if you have any further concerns. I am happy to help you.