Fork me on GitHub
#sql
<
2021-05-08
>
nha11:05:19

Hello! I am looking at writing a query like this one https://stackoverflow.com/a/15710598/1327651 It seems easy enough with the helpers in next-jdbc like as-keys and by-keys. But if the values are not for strings but Dates/ZonedDateTime I would need to convert them myself? Or is there a way I can reuse the existing conversions? https://github.com/seancorfield/next-jdbc/blob/91dda2cdae3f9e897a54fe21edf8467acae8aa0d/doc/prepared-statements.md#prepared-statement-parameters Or should I look at calling eg. honeysql’s to-sql (I am using this dependency yet).

nha12:05:20

^I went with a custom to-sql protocol

nha20:05:22

I think I have dates working in other places using next.jdbc so that should be setup already, though I'll need to double check. Thanks!