| Subject | Re: [firebird-support] Firebird ins't updating date/time automatically |
|---|---|
| Author | |
| Post date | 2018-10-24T14:41:41Z |
Hi,
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.
Eli
---In firebird-support@yahoogroups.com, <liviuslivius@...> wrote :
Hi,
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?
Regards,
Karol Bieniaszewski
-------- Oryginalna wiadomość --------
Od: "eliflavio@... [firebird-support]" <firebird-support@yahoogroups.com>
Data: 22.10.2018 19:08 (GMT+01:00)
Do: firebird-support@yahoogroups.com
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.
Eli