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