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


	The Toolkit for Online Communities 15939 Community Members, 0 members online, 2315 visitors today			Log In	Register

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

OpenACS Home : Forums : OpenACS Q&A : Response to sysdate() problem with OpenAcs 4 : One Message

Back to OpenACS Q&A

8: Response to sysdate() problem with OpenAcs 4 (response to 1)

Posted by Roberto Mello on 10/26/01 12:26 AM

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.

Back to OpenACS Q&A