On 7/24/2013 10:37 AM, Julien Danjou wrote:
Not really unfortunatelly, unless I've missed the obvious. I've still have no clue on how to insert "2013-01-01 12:00:00 UTC" into PG. Your first example inserted "2013-01-01 04:00:00 UTC", and the second example inserted "2013-01-01 03:00:00 UTC". Thanks!
Baring the rest of the issues you might be experiencing with these layered systems, "2013-01-01 11:00:00" is considered timezoneless (ie: local zone of whatever computer is interpreting it). If you wish to insert "2013-01-01 04:00:00 UTC" the correct spelling is "2013-01-01 04:00:00Z" or "2013-01-01 04:00:00+0" which are two spellings of a timestamp in UTC. Both should be recognized by postegresql correctly.
This call to local-time:format-timestring should allow you to produce timestamps in the correct zone. (local-time:format-timestring nil (local-time:encode-timestamp 0 0 0 12 01 01 2013) :timezone local-time:+utc-zone+)
This wikipedia article should help. https://en.wikipedia.org/wiki/ISO_8601
Hope this helps, Russ Tyndall Acceleration.net Software Developer