Postgres Pro
Downloads
Home   >   mailing lists

date_part bug? - Mailing list pgsql-sql

From Salvador Mainé
Subject date_part bug?
Date
Msg-id 3AC1C27D.4D64E67E@yahoo.com
Whole thread Raw
List pgsql-sql
Tree view 
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?

-- 
Salvador Mainé

pgsql-sql by date:

Previous
From: "Mikheev, Vadim"
Date:
Subject: RE: [HACKERS] Re: possible row locking bug in 7.0.3 & 7.1
Next
From: "Md. Intekhab Alam"
Date:
Subject: ...