Subject IB Time problem
Author Brian Dunstan
Hi,

I have a very strange problem, that has appeared on only 1 of many sites.

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.

I am running NT 4 and Borland IB 6.01. None of my other sites exhibit this
problem.

The system has no daylight savings enabled.

What could be causing this?

TIA,

Brian