Re:Pg_cron
by vlovich123 on Tuesday January 04, 2022 @08:26AM
(#29794431)
Why? Can’t you just convert that business hour to UTC?
[ Parent
| on HN ]
Re:Pg_cron
by boondaburrah on Tuesday January 04, 2022 @08:32AM
(#29794476)
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.