Hacker News new | ask | show | jobs
by vlovich123 1625 days ago
Why? Can’t you just convert that business hour to UTC?
1 comments

ho boy, before I break out "falsehoods programmers believe about time,"[0] nobody wants to manually have to rewrite the UTC time something's supposed to run at when the business hours keep changing relative to UTC for (at the most basic) Daylight Savings reasons.

[0] https://infiniteundo.com/post/25326999628/falsehoods-program...

(if this is your first time seeing this article, have fun! also check out the one about names.)

You don't have to do that "manually". Postgres supports the conversion using the `at time zone` operator.
This extension uses cron syntax and only supports GMT.