Postgres Pro
Downloads
Home   >   mailing lists

BUG in date_part - Mailing list pgsql-bugs

From Alexandru COSTIN
Subject BUG in date_part
Date
Msg-id LOeD5.13$Nr6.837@nreader1.kpnqwest.net
Whole thread Raw
Responses Re: BUG in date_part
Re: BUG in date_part
List pgsql-bugs
Tree view 
Hello,
    I've discovered a bug in the date_part function. It returns 25 when
doing select date_part('day','2000-03-26'::date);
    Anyway, this isn't happening if casting the date to timestamp
    select date_part('day','2000-03-26'::timestamp);

                Alexander

pgsql-bugs by date:

Previous
From: Suchandra Thapa
Date:
Subject: Possible bug
Next
From: Bruce Momjian
Date:
Subject: Re: BUG in date_part