|
From: Jai S. <Jai...@ka...> - 2012-07-03 11:31:30
|
Hi, I work for a company where developers are based in Stockholm (CET) and I am based in london. We have a time_dimension table in our DW which looks like this for the developers: Time_dimension_id Full_time hour minute second 1 00:00:00 0 0 0 2 00:00:01 0 0 1 3 00:00:02 0 0 2 However on mine, it shows up as: Time_dimension_id Full_time hour minute second 1 01:00:00 0 0 0 2 01:00:01 0 0 1 3 01:00:02 0 0 2 As you can see there is an error with my full_time column. This is because I am not in CET time zone like the developers. I have tried other client software and with theirs im able to change my timezone to 'CET' and the problem is fixed. However I cant seem to change the timezone within SquirreL SQL. Any help would be appreciated! Br Jai The information in this email is confidential and may be legally privileged. If you are not the intended recipient, you must not read, use or disseminate that information and upon reception, permanently delete the original and destroy any copies. Although this email and any attachments are believed to be free of any virus or any other defect which might affect any computer or IT system into which they are received and opened, it is the responsibility of the recipient to ensure that they are virus free and no responsibility is accepted by Kambi for any loss or damage arising in any way from receipt or use thereof. |
