Re: Error in date_trunc function? - Mailing list pgsql-general

From Tom Lane
Subject Re: Error in date_trunc function?
Date
Msg-id 14984.1004586517@sss.pgh.pa.us
Whole thread Raw
In response to Error in date_trunc function?  (Marat Khairullin <xmm@rambler.ru>)
List pgsql-general
Marat Khairullin <xmm@rambler.ru> writes:
> Compare TZ part of date_func function output with param 'month' and other.
> Is it error?

Depends.  Do those various dates fall in daylight-savings or standard-time
territory in your timezone?  They all look like reasonable candidates
for local midnight to me, if you are in a northern-hemisphere zone that
switches to standard time sometime during October.

            regards, tom lane

pgsql-general by date:

Previous
From: Tatsuo Ishii
Date:
Subject: Re: CP1250 to and from Unicode conversion, how?
Next
From: Tom Lane
Date:
Subject: Re: alter table workaround