Re: return error from date_part

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: toni-m(at)usa(dot)net, pgsql-bugs(at)postgresql(dot)org
Subject: Re: return error from date_part
Date: 2001-03-23 20:27:36
Message-ID: 9602.985379256@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

pgsql-bugs(at)postgresql(dot)org writes:
> When I have a specific select, only whitch this date return a error.

> "SELECT date_part('day',fecha) AS day FROM fecha;

> day | fecha
> -----+------------
> 24 | 2001-03-25
> (1 row)

Is that a daylight-savings-time transition day in your timezone?
If so, this is a known bug in date-to-timestamp conversion (try
"SELECT fecha::timestamp" to see what's going on).

It's fixed in 7.1.

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2001-03-23 21:31:03 Re: 7.0.3 postmaster memory leak with aborted transactions
Previous Message pgsql-bugs 2001-03-23 19:34:26 return error from date_part