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