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!
--
View this message in context: http://old.nabble.com/SQuirreL-SQL-client-time-zone-problem-tp34106886p34106886.html
Sent from the squirrel-sql-users mailing list archive at Nabble.com.
|