search

mariuz / flamerobin

FlameRobin is a database administration tool for Firebird RDBMS. Our goal is to build a tool that is: lightweight (small footprint, fast execution) cross-platform (Linux, Windows, Mac OS X, FreeBSD) dependent only on other Open Source software
http://flamerobin.org
MIT License
214 stars 66 forks source link

TimeZone issues with Flamerobin #381

Open DaltonCalford opened 3 months ago

DaltonCalford commented 3 months ago

Flamerobin does not display time zone information even if the returned query specifically asks for results that would include timezone information.

For example (firebird isql, firebirdsql 5) SQL> select current_timestamp from rdb$database;

                                    CURRENT_TIMESTAMP

========================================================= 2024-07-02 13:54:31.0310 Etc/UTC

SQL>

Flamerobin example image

This is even when flamerobin understands the returned value has a timezone value

image