Fork me on GitHub
#honeysql
<
2022-12-14
>
Abhinav12:12:45

HI, is there a way to write this in honeysql? I couldn’t find any mention of the epoch from … syntax. thanks

SELECT EXTRACT(EPOCH FROM (timestamp_B - timestamp_A))
FROM TableA

slipset13:12:09

[:extract
     [:epoch-from
      [:-
       [:raw "current_timestamp"]
       :lastUpdated]]]

clojure-spin 1
❤️ 2
slipset13:12:27

Is a piece of code from our codebase. I’m sure you can adapt that?