Обсуждение: when started century? PostgreSQL vs Oracle diff

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?

Best regards
Pavel Stehule

_________________________________________________________________
Chcete sdilet sve obrazky a hudbu s prateli? http://messenger.msn.cz/

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
> 

"Pavel Stehule" <pavel.stehule@hotmail.com> writes:

> 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?

out of curiosity, what was your actual test?

-- 
greg