|
[Squirrel-sql-users] Timezone issues with SQL Server
From: Charles Hudak <charles.hudak@ca...> - 2005-12-20 19:15
|
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. |
| Thread | Author | Date |
|---|---|---|
| [Squirrel-sql-users] Timezone issues with SQL Server | Charles Hudak <charles.hudak@ca...> |