hello everyone its possible with jdbc/insert to call functions like NOW() ?

unlikely

is possible for this to work?

(defn update-campaigns-status [db-spec campaigns]
  (jdbc/update! db-spec
                :tb_campanha_usuario
                {:dataAgendamento (db/now)}
                [“idCampanha in ?” campaigns]))

where campaigns is a vector

@plins insert! and update! work with Clojure data structures. If you want to use SQL functions, you'll need to use execute!.

@plins for your question regarding in, you need to provide enough ? to match your vector: (into [(str "idCampanha in ( " (str/join "," (repeat (count campaigns))) " )"] campaigns) is what you are looking for.

so you would construct ["idCampanha in ( ?, ?, ?, ? )" campaign1 campaign2 campaign3 campaign4] (if campaigns had four elements)