Subject Re: [firebird-support] Firebird ins't updating date/time automatically

Firebird 3.0

Yes, I've tried everything, it doesn't update the time at least I restart the Firebird service. 

But I found out a interesting thing, the problem only occurs if I change timezone ou DST, in this case, Firebird doesn't detect it. 

But, if I change for exemple de hour of the date manually, then Firebird updates CURRENT_TIMESTAMP correctly.

Therefore, it seems like the problems is related with timezone change.

Thank you.


---In, <liviuslivius@...> wrote :


which Firebird version? I never hear about such strange issue. How do you checked this? Start new transaction and select current_timestamp from rdb$database
What is the result?

Karol Bieniaszewski

-------- Oryginalna wiadomość --------
Od: "eliflavio@... [firebird-support]" <>
Data: 22.10.2018 19:08 (GMT+01:00)
Temat: [firebird-support] Firebird ins't updating date/time automatically


My clients are 24/7 and when daylight save starts automatically in Windows, CURRENT_TIMESTAMP continues returning the old date/time until the Firebird is restarted.

What can I do to solve this problem without restarting the service?

Thank you.