Returns a new
timestampinstance corresponding to the specified time elements. The offset is the number of seconds offset from UTC of the locale. If offset is not specified, the offset will be guessed from the timezone. If atimestampis passed as the into argument, its value will be set and thattimestampwill be returned. Otherwise, a newtimestampis created.Hope that helps.
Sabra
Hi there,
I'm struggling with timezone handling in Postmodern. I'm using timestamp
with time zone column types, and I'm looking for the correct way to feed
postmodern such information on insert. Basically, I don't see any class
that would fit. I've tried to grep through the code but didn't find much
about timestamp/timezone handling.
Concretely, I'm having UTC timestamp that I want to insert into those
timestamp-with-time-zone columns, but I don't know how to tell
Postmodern that it should postfix them with something like +00 so PG
understand it should not default them to its default timezone.
On the same topic, I thought that one easy solution would be to set the
session timezone to UTC. It's easy enough to come with a macro doing a
SET TIMEZONE='UTC' before each request, but honestly, I'd like to avoid
that and do it only at connection time.
Now, I've read through cl-postgres code, and I was hoping being able to
plug my code at connection time, but it seems everything is defined as
function and not as method, which seems weird to me, and not really
pluggable in the end.
Any hint appreciated!
Cheers,
--
Julien Danjou
;; Free Software hacker ; freelance consultant
;; http://julien.danjou.info