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

Collapse
Posted by Roberto Mello on
Claudio,

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.