Fork me on GitHub
Slack Archive

This page is not created by, affiliated with, or supported by Slack Technologies, Inc.

2018-10-21

Channels

#sql
<
2018-10-21
>
martinklepsch17:10:51

(sql/query db-spec ["SELECT * FROM builds WHERE analysis_triggered_ts = DATETIME('now', 'localtime', '? days')" days])))
getting an IndexOutOfBounds exception for this, can be fixed with something like this: 
(sql/query db-spec ["SELECT * FROM builds WHERE analysis_triggered_ts = DATETIME('now', 'localtime', ?)" (str "-" days " days")])
but wondering if there's a better way?