clojureql select between two dates

Question

How would I use clojureql to select between two dates? Hopefully something like this:

@(-> (table :abc)
     (select (where (between d1 d2))))

score 6 · Answer 1 · answered Sep 01 '11 at 12:10

6

You can write your own between

(defmacro between
  [x min max]
  `(and (< ~min ~x) (< ~x ~max)))

This will be compatible with ClojureQL.

answered Sep 01 '11 at 12:10

John Cromartie

4,184
27
32

score 4 · Accepted Answer · answered Aug 31 '11 at 20:52

There is no BETWEEN, and while you might be tempted to use Lisp-y multiple-argument <, that does not work either:

;; invalid SQL output
hello-cql.core> (select (table :abc) (where (< 10 :a 20)))
SELECT abc.* FROM abc WHERE (10 < a < 20)

;; valid SQL output
hello-cql.core> (select (table :abc) (where (and (< 10 :a) (< :a 20))))
SELECT abc.* FROM abc WHERE ((10 < a) AND (a < 20))

clojureql select between two dates

2 Answers2