Subject | IB Time problem |
---|---|
Author | Brian Dunstan |
Post date | 2001-08-06T03:17:49Z |
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
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