how do I parameterize the time string in this: (jdbc/query db ["select TIME '9:00:00'"])

I've tried (jdbc/query db ["select TIME ?" "'9:00:00'"]), (jdbc/query db ["select TIME ?" "9:00:00"]) and (jdbc/query db ["select TIME '?'" "9:00:00"]) but none of them works

I've never seen that syntax but I wouldn't expect you to be able to parameterize that part of a select.

actually it's part of an overlaps. I used select here to simplify my question

I guess it'll be cast type's job there

so I ended up with (jdbc/query db ["select cast (? as time)" "9:00:00"])

@myguidingstar with Postgres, I think you can also wrap the parameterised value with a org.postgresql.util.PGObject,

(doto (PGobject.) 
  (.setType "time") 
  (.setValue "9:00:00"))