Fork me on GitHub
#sql
<
2017-12-30
>
sandbags12:12:53

I'm finding that clojure.java.jdbc/query is returning a Sqlite TIMESTAMP column as a string. Is this expected?

sandbags12:12:27

i'm starting to wonder whether using sqlite to get the project bootstrapped quickly might have been a mistake

sandbags12:12:40

more peculiar still, there are two timestamp columns and its returning them as strings in different formats

sandbags12:12:42

presumably related to how the data is getting in there, one is a DEFAULT CURRENT TIMESTAMP the other assigned from a clj-time date-time

sandbags12:12:34

not sure whether to try and debug this or just switch to MySQL or PG