Hi all,
any suggestion how to run this kind of que...
# servera
alon shoshani.86
04/07/2022, 3:12 PMHi all,
any suggestion how to run this kind of query in postgresql with expose?
Copy code
UPDATE events_affecting_transit
SET estimated_affect_end_time = estimated_affect_end_time + interval '5 hour'
WHERE current_timestamp > estimated_affect_end_timealon shoshani.86
04/07/2022, 3:48 PMwhen I'm trying do like that,
alon shoshani.86
04/07/2022, 3:49 PMI get "Cannot cast exception"
t
Ties
04/12/2022, 9:14 AMNo experience with exposed. But I would guess "estematedEffecttime as instant" gives you the error, since it's not actually an instant but a column
a
alon shoshani.86
04/12/2022, 1:36 PM@Ties already tried, it says can cast estematedEffecttime as instant
2 Views