Postgres Pro
Downloads
Home   >   mailing lists

Re: extract epoch bug - Mailing list pgsql-bugs

From Tom Lane
Subject Re: extract epoch bug
Date
Msg-id 13219.1120575855@sss.pgh.pa.us
Whole thread Raw
In response to extract epoch bug  (olav@venus.jordforsk.no (Hans Olav Eggestad))
List pgsql-bugs
Tree view 
olav@venus.jordforsk.no (Hans Olav Eggestad) writes:
> I've just installed v8.0.3 and tested the 'epoch' part of extract, which for
> my applications is fundamental. here is the result:
> [ snip ]

Nothing wrong with that that I can see.  If you want a date to be
interpreted as midnight GMT rather than midnight your local zone,
either say so or set TimeZone to GMT.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Achilleus Mantzios
Date:
Subject: Re: extract epoch bug
Next
From: "Tzahi Fadida"
Date:
Subject: BUG #1755: SPI_execute_plan not releasing memory even after SPI_finish