Re: when started century? PostgreSQL vs Oracle diff

Pavel Stehule wrote:
> Hello
>
> I am testing comformity between PostgreSQL and Oracle. I found one
> difference. Century started 1900-01-01 for Oracle and 1901-01-01 for
> PostgreSQL. What value is good?

Hello,

I think that 1901 is the correct year.

( The first century started in year 1 and ended in year 100.
There was no year 0 ...

Also, the 2nd millenium started in 2001, not in 2000 :
http://staff-www.uni-marburg.de/~schittek/millenni.htm )

Best wishes,
Adrian Maier

> Best regards
> Pavel Stehule
>
> _________________________________________________________________
> Chcete sdilet sve obrazky a hudbu s prateli? http://messenger.msn.cz/
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
> choose an index scan if your joining column's datatypes do not
> match
>