6 ms·
"overengineering" UPDATE appointments SET starts_at_utc = local_time AT TIME ZONE timezone_name WHERE timezone_name = 'America/Vancouver' AND
by dqv 3mo ago
"overengineering"
UPDATE appointments
SET starts_at_utc = local_time AT TIME ZONE timezone_name
WHERE timezone_name = 'America/Vancouver'
AND starts_at_utc > now();
- pphysch 3mo agoYou elided the part where you are adding an extra column to your database just for this rare corner case.