Forum OpenACS Q&A: Response to Installation questions and suggestions

Collapse
Posted by Ken Chakiris on
I am running postgres 7.0b3. I think there is something wrong with the to_date function. This is what I get when I do the first test on the acceptance test page.
bsim=> select to_date('1-1-2000', 'MM-DD-YYYY') as y2k from dual ;

y2k
-------------
0002-12-29 BC
(1 row)

bsim=> select * from dual ;
sysdate
----------------------
2000-04-04 14:05:25-07
(1 row)
Why is this?