Ok this works in psql:
mydata=# select now() from dual;
now
------------------------
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() !
-Bob