| From: | Richard Huxton <dev(at)archonet(dot)com> |
|---|---|
| To: | salva(at)ronincoders(dot)com |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: date_part bug? |
| Date: | 2001-03-31 07:35:35 |
| Message-ID: | 3AC588C7.9210F3AC@archonet.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
"Salvador Mainé" wrote:
>
> Hello:
>
> I'm using postgres 7.0.2. When I use date_part('day', date) sometimes I
> get wrong values. Ie:
> and date_part('day', '1999-3-28')=27
>
> and date_part('day', '2000-3-26')=25
>
> Is it a bug? Is there any SQL equivalent function?
I remember some issues with summertime settings and timezones (I think
the person how originally found the bug was in New Zealand and PG got
confused by a +13 timezone) - don't know if this might affect you or if
it was fixed before 7.0.2
You might want to try the to_char function and see if that displays the
same problem.
- Richard Huxton
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Huxton | 2001-03-31 07:41:59 | Re: Function x returns opaque in error typeidTypeRelid |
| Previous Message | Sharmad Naik | 2001-03-31 07:33:38 | Library Management System |