Hello, Maybe it’s a question for pgsql-novice, but I have a
problem converting to and from unix times. In particular, it seems that a round
trip unix->PG->unix does not return the original timestamp: select extract(epoch from timestamp 'epoch'); date_part ----------- -3600 Shouldn’t that be zero? My timezone is Europe/London (but
does it matter?). Thanks Alberto |