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

Posted by Bob OConnor on

Ok this works in psql:

mydata=# select now() from dual;
 2001-10-24 14:51:05-04
(1 row)

But this does not:

mydata=# select current_timestamp() from dual;
ERROR:  parser: parse error at or near ")"

I guess I'll stick with the here and NOW() !