When timezones change, CURRENT_TIMESTAMP returns wrong time [CORE2046]

FirebirdSQL / firebird

Firebird server, client and tools

https://www.firebirdsql.org/

1.23k stars 212 forks source link

When timezones change, CURRENT_TIMESTAMP returns wrong time [CORE2046] #2482

Open firebird-automations opened 16 years ago

firebird-automations commented 16 years ago

Submitted by: David Henningsson (diwic)

Votes: 1

CURRENT_TIMESTAMP returns the current time in the local time zone. However, when the time zone is changed, CURRENT_TIMESTAMP is not updated accordingly, so the result of CURRENT_TIMESTAMP is wrong. The Firebird service has to be restarted in order for the time zone change to have effect.

firebird-automations commented 12 years ago

Commented by: Harri Vartiainen (harriv)

I noticed this issue with version 2.1.3 under Windows XP Embedded.