Hacker News new | ask | show | jobs
by pc86 1900 days ago
Not only that but in T-SQL, `AT TIME ZONE` takes DST into account but not in the names. So something like:

    SELECT CreatedDate AT TIME ZONE 'UTC' AT TIME ZONE 'Eastern Standard Time' FROM MyTable
would in fact return `CreatedDate` at Eastern Daylight Time if executed today.