Home > mailing lists

date_part bug? - Mailing list pgsql-admin

From	Salvador Mainé
Subject	date_part bug?
Date	March 28, 2001 09:22:11
Msg-id	3AC1C228.EBAD97ED@yahoo.com Whole thread Raw
Responses	Re: date_part bug? (Tom Lane <tgl@sss.pgh.pa.us>)
List	pgsql-admin

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?

--
Salvador Mainé

pgsql-admin by date:

From: Bruce Momjian
Date: 27 March 2001, 21:41:35
Subject: pgmonitor and Solaris

From: Mario Jorge Nunes Filipe
Date: 28 March 2001, 09:57:54
Subject: A crashing query

date_part bug? - Mailing list pgsql-admin

Previous

Next