Helen Borrie wrote:

>> ...
>> How can I make my query working under Dialect 3?
>
> select * from USER_SESSION
> WHERE (cast ('now' as timestamp) - LastPageTime) > (1/60);
>
> or
>
> select * from USER_SESSION
> WHERE (CURRENT_TIMESTAMP - LastPageTime) > (1/60);
>

Note that (1/60) will evaluate to 0.


--
Aage J.