Forum OpenACS Q&A: Response to sysdate() problem with OpenAcs 4

Posted by Roberto Mello on

The reason why sysdate() works in your 3.2.5 database, is because that function is defined in the 3.2.5 datamodel, but it probably isn't defined in the 4.2 datamodel. The functions of one database are not transplanted to another.

As others have noted, it's better to use the standard CURRENT_TIMESTAMP.