using now() in EJB-QL

On my development system I'm using Postgres as my database. I'm deploying
on SQL Server. I have an EJB-QL query that works using now() to compare
against a date field in the database against Postgres, but the SQL Server
JDBC driver returns an error saying it doesn't know what to do with now().
Is there a way I can structure my EJB-QL query so that it will compare the
current date against a database record on both Postgres and SQL Server?
  -M@
Received on Tue 02 Apr 2002 09:54:26 -0800