Clojurians Log v2
Clojure programming
Channels
Apps
honeysql 2024-09-24
not sure if this is the right place to ask, but does anyone have a better way of converting PGIntervals (intervals from postgres database) to seconds than this?
(defn pginterval->seconds [^org.postgresql.util.PGInterval interval]
(+ (.getSeconds interval)
(* 60 (.getMinutes interval))
(* 60 60 (.getHours interval))
(* 60 60 24 (.getDays interval))
(* 60 60 24 365.25 (.getYears interval))))
p-himik 2024-09-24T08:17:22.563329Z
Something like
(let [d (java.util.Date. 0)]
(.add interval d)
(/ (.getTime d) 1000))ok. I think I have an anchor date in the record I can use and from that I can get a java.util.Date for the start and the end, convert them to java.time.Instant objects and do the date arithmetic from there (that I think will be close enough for what I'm doing in this instance)
p-himik 2024-09-24T08:31:24.289859Z
You don't need Instant to subtract two dates to get seconds?..
p-himik 2024-09-24T09:21:52.721789Z
I see. Also note that there's add(Calendar). Might be more convenient in your case, dunno.
possibly. I think the general approach of - add the interval to some kind of java.util.Date to get a start and end date and then go from there was the mental flip I needed
(mentioning the leap years helped with that)
TIL: https://cljdoc.org/d/com.github.seancorfield/honeysql/2.6.1161/api/honey.sql.pg-ops#-%3E%3E, which helped me translate some sql