4 ms·
shudder I can only imagine needing to toss in standard/daylight timezone switch in there. Billing code really is the pinnacle of developer pain. It mixes the a
by deckard1 6y ago
shudder
I can only imagine needing to toss in standard/daylight timezone switch in there. Billing code really is the pinnacle of developer pain. It mixes the arbitrariness of special case business and customer rules with the absolute horror of time and date math.
- pc86 6y agoNot 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.