[HACKERS] Dates BC.

[Kurt Roeckx]

I find this a little strange:

select date_part('year', '0002-01-01 BC'::date);
 date_part
-----------
        -1

It seems 1 BC and 0 are the same year.

In backend/utils/adt/formatting.c:

        if (tmfc.bc)
        {
                if (tm->tm_year > 0)
                        tm->tm_year = -(tm->tm_year - 1);

It this normal or a bug?


Kurt


---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster