News for hackers. Stuff that matters.

A comment on Things I learned while developing a billing system. Parent comment

Re:Things I learned while developing a billing system by pc86 on Monday April 05, 2021 @06:32PM (#26705491)
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.
[ Parent | on HN ]

There are no comments on this comment yet.