夏令时与跨时区转换器

// 将指定时间转换为目标城市的法定民用显示时间
function formatInTimezone(date: Date, timeZone: string): string {
  return new Intl.DateTimeFormat('zh-CN', {
    timeZone,
    dateStyle: 'full',
    timeStyle: 'long',
    hourCycle: 'h23',
  }).format(date);
}

// 检测目标时区在指定日期是否正处于夏令时
function isTimezoneInDST(timeZone: string, date = new Date()): boolean {
  const year = date.getFullYear();
  const getOffset = (d: Date) => {
    const parts = new Intl.DateTimeFormat('en-US', {
      timeZone,
      hourCycle: 'h23',
      year: 'numeric', month: 'numeric', day: 'numeric',
      hour: 'numeric', minute: 'numeric', second: 'numeric'
    }).formatToParts(d);
    const p: Record<string, number> = {};
    parts.forEach(pt => { if (pt.type !== 'literal') p[pt.type] = parseInt(pt.value, 10); });
    return Date.UTC(p.year, p.month - 1, p.day, p.hour === 24 ? 0 : p.hour, p.minute, p.second) - d.getTime();
  };

  const janOffset = getOffset(new Date(Date.UTC(year, 0, 15)));
  const julOffset = getOffset(new Date(Date.UTC(year, 6, 15)));
  const currentOffset = getOffset(date);

  return currentOffset === Math.max(janOffset, julOffset) && janOffset !== julOffset;
}

from datetime import datetime
from zoneinfo import ZoneInfo

# 构建纽约本地开会时间
ny_tz = ZoneInfo("America/New_York")
london_tz = ZoneInfo("Europe/London")
shanghai_tz = ZoneInfo("Asia/Shanghai")

# 设定排期：2026年11月2日 纽约当地上午 10:00
meeting_ny = datetime(2026, 11, 2, 10, 0, tzinfo=ny_tz)

# 无损转换为伦敦与上海本地时间
meeting_london = meeting_ny.astimezone(london_tz)
meeting_shanghai = meeting_ny.astimezone(shanghai_tz)

print("纽约时间: ", meeting_ny.strftime("%Y-%m-%d %H:%M %Z (UTC%z)"))
print("伦敦时间: ", meeting_london.strftime("%Y-%m-%d %H:%M %Z (UTC%z)"))
print("北京时间: ", meeting_shanghai.strftime("%Y-%m-%d %H:%M %Z (UTC%z)"))
# 输出是否处于夏令时布尔值
print("纽约是否处于夏令时:", bool(meeting_ny.dst()))

package main

import (
	"fmt"
	"time"
)

func main() {
	// 加载标准 IANA 时区库
	locNY, _ := time.LoadLocation("America/New_York")
	locLondon, _ := time.LoadLocation("Europe/London")

	// 设定秋季错位过渡周的具体日期 (2026年10月28日)
	meetingTime := time.Date(2026, 10, 28, 14, 0, 0, 0, locNY)

	// 计算对应的伦敦挂钟时间
	londonTime := meetingTime.In(locLondon)

	zoneName, offsetSec := meetingTime.Zone()
	fmt.Printf("纽约: %s (%s, UTC%+d)
", meetingTime.Format(time.RFC3339), zoneName, offsetSec/3600)
	
	lName, lOffset := londonTime.Zone()
	fmt.Printf("伦敦: %s (%s, UTC%+d)
", londonTime.Format(time.RFC3339), lName, lOffset/3600)
}

-- 将底层 UTC 时间戳按目标城市时区格式化输出
SELECT 
  event_id,
  created_at AT TIME ZONE 'UTC' AS utc_time,
  created_at AT TIME ZONE 'America/New_York' AS ny_local_time,
  created_at AT TIME ZONE 'Asia/Shanghai' AS beijing_local_time
FROM audit_logs
WHERE created_at >= '2026-10-01 00:00:00Z'
LIMIT 10;

-- 提取特定时间点纽约当地当前的 UTC 偏移小时数
SELECT 
  timezone('America/New_York', now()) AS wall_clock,
  EXTRACT(timezone FROM now() AT TIME ZONE 'America/New_York') / 3600 AS current_offset_hours;