Thank you very much, Helen. It works great!

--- In firebird-support@yahoogroups.com, "lintao_nz" <lintao_nz@...>
wrote:

>
> 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
>