*shudder* I can only imagine needing to toss in standard/daylight timezone switc... | Hacker News

Hacker News new | past | comments | ask | show | jobs | submit

login

deckard1 on April 5, 2021 | parent | context | favorite | on: Things I learned while developing a billing system

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 on April 5, 2021 [–]

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.

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact