> When I run this SQL:
>
> select cast ('now' as timestamp) from rdb$database;
>
> the time returned is always the current time + 30 minutes.
>
> IOW, if the time is 11:00 then the sql will return 11:30.
>
> The problem occurs whichever workstation runs the SQL
> statement. Even if I run the statement from WISQL running
> on the server computer I still get the same result.

Well that much at least is to be expected, since the query actually
runs on the server and so will always return the time reported on the
server.

Check the environment settings on the server. I cant remember the
exact name but I think there can be an environment variable that
controls the GMT offset of the reported time. If you need more info
let me know, I think it was discussed in my PGP documentation
somewhere.


Cant think of anything else and the moment.


Geoff Worboys
Telesis Computing