On Sunday, 17 May 2015 01:46:14 UTC+10, g vim wrote: > > <snip/> > > (c/to-timestamp "1967-07-31 06:30:00 America/Caracas") > > .... evaluates to nil. However: > > (c/to-timestamp "1967-07-31 06:30:00") > > .... gives me an: #inst "1967-07-31T06:30:00.000000000-00:00" , > whatever that is, so I checked the clj-time docs and it appears > to-timestamp doesn't handle timezones. > > Any ideas? >
Looks like you might want this: user> (clj-time.format/parse (clj-time.format/formatter "yyyy-MM-dd HH:mm:ss ZZZ") "1967-07-31 06:30:00 America/Caracas") #object[org.joda.time.DateTime 0x79e05a0 "1967-07-31T10:30:00.000Z"] I suspect you'll then need some further work to make sure that the Joda DateTime object correctly converts into what you actually want stored in the database when it's set on the SQL PreparedStatement (something like this <http://tapestryjava.blogspot.ie/2014/09/postgres-jdbc-time-zones.html>, but extending the type to Joda's DateTime rather than java.util.Date) -- or alternatively you might be OK just coercing the above to a java.sql.Date or java.sql.Timestamp. > gvim > -- You received this message because you are subscribed to the Google Groups "Clojure" group. To post to this group, send email to clojure@googlegroups.com Note that posts from new members are moderated - please be patient with your first post. To unsubscribe from this group, send email to clojure+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/clojure?hl=en --- You received this message because you are subscribed to the Google Groups "Clojure" group. To unsubscribe from this group and stop receiving emails from it, send an email to clojure+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
