Thanks for all your suggestions.

I have found an environment variable:
TZ=eet-10

I have no idea what it means, but I changed it to
TZ=eet-9.5
and have rebooted the server, but it made no difference. I can't see
anything else that looks like time zone or Daylight Savings.

The puzzle is, why or how is it that IB is getting a different time to the
clock displayed by windows (in the task bar).

I don't understand how it could be a timezone issue. I would have thought if
the timezone was wrong then both the IB Server and the windows clock would
be effected equally.

I have searched the registry for Timezone and Daylight savings settings and
everything I saw looked OK.

Brian

> -----Original Message-----
> From: Geoff Worboys [mailto:geoff@...]
> Sent: Monday, 6 August 2001 12:04 PM
> To: IBObjects@yahoogroups.com
> Subject: Re: [IBO] IB Time problem
>
>
> > 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
>
>
> ------------------------ Yahoo! Groups Sponsor
> ---------------------~-->
> Small business owners...
> Tell us what you think!
> http://us.click.yahoo.com/vO1FAB/txzCAA/ySSFAA/PhFolB/TM
> --------------------------------------------------------------
> -------~->
>
>
>
> Your use of Yahoo! Groups is subject to
> http://docs.yahoo.com/info/terms/
>
>