Things I learned while developing a billing system

Re:Things I learned while developing a billing system by deckard1 on Monday April 05, 2021 @06:26PM (#26705439)

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.

[ Parent | on HN ]

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 ]