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
Show quoted text
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