Tom Lane <[EMAIL PROTECTED]> writes: > If we make CC treat 2000 as being in the 20th century, what should YY > do?
Report "00", IMVHO. There's no year "0" so year 1 AD is "CC=1, YY=1". Year 100 is "CC=1, YY=00", year 1000 is "CC=10, YY=00", year 2000 is "CC=20, YY=00" (1900 is "CC=19, YY=00"). Centuries change on years ending with '01', years ending with '00' are from the previous century :-) But for millenia the thing is diffent... ;-) (Just to complicate a bit more) > Perhaps more to the point, how do these things act in Oracle? > to_char is basically an Oracle-compatibility function so we should > adopt their bugs :-( I can't answer that... But my expectations are like Akio's. -- Jorge Godoy <[EMAIL PROTECTED]> ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
