Subject Re: [firebird-support] FB Server and timezone on Win32
Author Daniel Rail

At October 20, 2004, 15:50, russellbelding wrote:

> I am wondering about the date and time services in the FB engine,
> when the timezone is changed on the server hosting the FB engine.

> Using
> a. FB on MS Server 2003 running as a sevice with Guardian
> also running.
> b. Win2K client with IBO 4.3Aa and delphi

> An application asks the FB server for the FB CURRENT_TIMESTAMP and
> displays it.

> On the server change the timezone to shift it several hours on the
> same day. During this leave the FB server running.

> Back on the client ask for the FB Engine Current_Timestamp. It shows
> time for the previous timezone setting.

Are both instances of fetching CURRENT_TIMESTAMP within the same
transaction? If your answer is yes, then there's your answer to your
question. CURRENT_TIMESTAMP is a transaction context variable,
basically it's gets assigned at the beginning of a transaction and
doesn't change until the transaction is committed or rollbacked.

Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (
ACCRA Med Software Inc. (