Re: Help with timestamp with timezone in YeSQL

2015-05-17 Thread gvim
'Turns out I was looking in the wrong place. YeSQL relieves you of all the clj-time formatting as you can simply add the PostgreSQL cast directly to your placeholder so this: -- name: add-birth On Sunday, 17 May 2015 01:46:14 UTC+10, g vim wrote: (c/to-timestamp "1967-07-31 06:30:

Re: Help with timestamp with timezone in YeSQL

2015-05-16 Thread Sam Roberton
On Sunday, 17 May 2015 01:46:14 UTC+10, g vim wrote: > > > > (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.0-00:00" , > whatever that is, so I che

Help with timestamp with timezone in YeSQL

2015-05-16 Thread Michael Cramm
Out of curiosity have you tried clj-time.coerce/to-sqs-time ? -- 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

Help with timestamp with timezone in YeSQL

2015-05-16 Thread gvim
I have a YeSQL query: -- name: add-birthINSERT INTO births (date_time) VALUES ('1967-07-31 06:30:00 America/Caracas') ... and all is well but my defquery equivalent: (add-birth fails because the date_time string is passed to PostgreSQL as a varchar, not a timestamp with timezone. So, t