Anyone?
# servera
alon shoshani.86
04/12/2022, 8:37 AMAnyone?
alon shoshani.86
04/12/2022, 8:38 AM@Rich you are the only one online 🙂
Any idea?
k
Kamil Kalisz
04/12/2022, 9:12 AMYou always can run pure sql using exec.
https://github.com/JetBrains/Exposed/wiki/FAQ#q-is-it-possible-to-use-native-sql--sql-as-a-string
a
alon shoshani.86
04/12/2022, 10:43 AMBut it there a solution?
alon shoshani.86
04/12/2022, 10:43 AMnot pure one
alon shoshani.86
04/12/2022, 10:43 AMIt's kind of basic to do it.//
alon shoshani.86
04/12/2022, 11:38 AMSo I'm trying running it with sql using prepareStatement.
when i'm trying to calculate column based on existing one, (add 5 minutes) like that
I get this error
alon shoshani.86
04/12/2022, 11:38 AMimage.png
alon shoshani.86
04/12/2022, 11:38 AMAny idea?
j
James Black
04/13/2022, 4:17 AMYou are trying to put a string into a timestamp column. If you drop the " min" after minutes and cast to a timezone it should work.
SET estimated_affect_end_time = ?::timezone, ...
so you cast the parameter to be of time timezone. My only concern is that you would need to get the timezone and then add the time in minutes to it and then set it. As it is written now won't work.
Or change estimated_affect_end_time to be a character varying type.
But this is why you are having a problem.