News for hackers. Stuff that matters.
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.)

Re:Pg_cron by castorp on Tuesday January 04, 2022 @09:20AM (#29794988)
You don't have to do that "manually". Postgres supports the conversion using the `at time zone` operator.
Re:Pg_cron by mulmen on Tuesday January 04, 2022 @09:30AM (#29795107)
This extension uses cron syntax and only supports GMT.