Fork me on GitHub
#sql
<
2016-09-06
>
sandbags22:09:20

I’m using clj-time (and clj-time.jdbc) to store now in a MySQL datetime column. Oddly although the data i’m saving looks right. e.g. #object[org.joda.time.DateTime 0x47725011 "2016-09-06T22:40:35.021Z”] what I’m seeing in the database is 2016-09-07 04:40:35. I’m using -Duser.timezone=UTC in project.clj. Bit puzzled. Any ideas where to look next?

sandbags22:09:12

note that if i manually insert a record using CURRENT_TIMESTAMP in the database the column gets the “right” value

sandbags22:09:02

my local timezone is BST (UTC+1) so that wouldn’t account for it being +6hr