オフセットの操作

SQL Serverで学ぶ時系列分析

Maham Faisal Khan

Senior Data Science Content Developer

DATETIMEOFFSET の構造

2019-04-10 12:59:02.3908505 -04:00

DECLARE @SomeDate DATETIMEOFFSET = 
    '2019-04-10 12:59:02.3908505 -04:00';

SELECT
    SWITCHOFFSET(@SomeDate, '-07:00') AS LATime;

LATime
2019-04-10 09:59:02.3908505 -07:00

DECLARE @SomeDate DATETIME2(3) =
    '2019-04-10 12:59:02.390';

SELECT
    TODATETIMEOFFSET(@SomeDate, '-04:00') AS EDT;

EDT
2019-04-10 12:59:02.390 -04:00

DECLARE @SomeDate DATETIME2(3) =
    '2016-09-04 02:28:29.681';

SELECT
    TODATETIMEOFFSET(
      DATEADD(HOUR, 7, @SomeDate),
      '+02:00') AS BonnTime;

BonnTime
2016-09-04 09:28:29.681 +02:00

SELECT
    tzi.name,
    tzi.current_utc_offset,
    tzi.is_currently_dst
FROM sys.time_zone_info  tzi
WHERE
    tzi.name LIKE '%Time Zone%';

SQL Serverで学ぶ時系列分析