Darcy Buskermolen <[EMAIL PROTECTED]> writes:
> SELECT date_part('day', (('2000-10-1 0:00'::datetime + '1 month') + '-1
> day'))::int4 AS days_in_month;
> days_in_month
> --
> 30
> (1 row)
This is not a bug, or at least it's not entirely clear what the behavior
ought to be. The is
this happens on FreeBSD 3.5-STABLE, running both 6.5.3 and 7.0.2
as well as FreeBSD 2.28-RELEASE running 6.4.(something)
At 03:52 PM 8/15/00 +1000, you wrote:
>At 22:38 14/08/00 -0700, Darcy Buskermolen wrote:
>>let me try this again...
>>
>>
>>Here is an other set of strange bugs I've discovered
At 22:38 14/08/00 -0700, Darcy Buskermolen wrote:
>let me try this again...
>
>
>Here is an other set of strange bugs I've discovered relating to dates.
>
>SELECT date_part('day', ('2000-11-1 0:00'::datetime + '-1day'))::int4 AS
>days_in_month;
>
> 31
>
>
>SELECT date_part('day', (('2000-10-1 0:0
let me try this again...
Here is an other set of strange bugs I've discovered relating to dates.
this bug only rears it's head for 1 day a year form what I can find..
october 31'st, the intent of the queries is to get the last day of a month..
SELECT date_part('day', ('2000-11-1 0:00'::date
