[Squirrel-sql-users] Timezone issues with SQL Server

[Charles H. <cha...@ca...>]

I noticed a timezone issue when using Squirrel with SQL Server. Most
databases, including sql server, AFAIK, store timestamp/date-time values
in GMT. Squirrel does not seem to recognize this when you ask it to use
date formatting which uses the timezone indicator.

For instance, if I create a new record at 11:50am PST, it shows up in
the squirrel client as 19:50, which is correct since this corresponds to
the GMT time of the timestamp. However, if I ask Squirrel to also
display the timezone, it shows as 19:50 PST, which is incorrect. The
time is 11:50 PST which is 19:50 GMT.

This email, including any attachments and files transmitted with it, are =
for the sole use of the intended recipient(s) to whom this email is =
addressed, and may contain confidential and/or privileged information. =
Any unauthorized review, use, disclosure or distribution is prohibited. =
If you are not the intended recipient, please be advised that you have =
received this email in error, and please contact the sender by reply =
email and destroy all copies (including all electronic and hard copies) =
of the original message. Thank you.