Hi all,

I try to convert my database from Dialect 1 to 3. Here is a simple
table:

CREATE TABLE USER_SESSION (
ID INTEGER NOT NULL,
LASTPAGETIME TIMESTAMP NOT NULL)

In dialect 1, I can run follow query:

select * from USER_SESSION
WHERE (('now' - LastPageTime) > (1/60));

But under Dialect 3, it always return follow error:

"Expression evaluation not supported."

How can I make my query working under Dialect 3?

Cheers,

Tao