Search found 5 matches

by circles85
Thu Jul 12, 2012 10:25 am
Forum: SQuirreL SQL Client
Topic: SQuirreL SQL client time zone problem
Replies: 9
Views: 55623

Re: SQuirreL SQL client time zone problem

The 'TYPE_NAME' is 'Time'. The 'DATA_TYPE' = '92'. I ran a few queries: select full_time at timezone 'CET' test from kdwh3.time_dimension where time_dimension_id = 1 output: test 02:00:00 select full_time at timezone 'UTC' test from kdwh3.time_dimension where time_dimension_id = 1 output: test 22:00...
by circles85
Sat Jul 07, 2012 2:04 pm
Forum: SQuirreL SQL Client
Topic: SQuirreL SQL client time zone problem
Replies: 9
Views: 55623

Re: SQuirreL SQL client time zone problem

I changed the URL to : jdbc:vertica://10.255.XX.XXX:5433/v_database?ConnSettings=SET TIMEZONE TO 'CET' and also jdbc:vertica://10.255.XX.XXX:5433/v_database?ConnSettings=SET TIMEZONE TO 'UTC' I then ran 'check timezone' and both times it changed the timezone successfully. However when I looked at th...
by circles85
Tue Jul 03, 2012 8:54 pm
Forum: SQuirreL SQL Client
Topic: SQuirreL SQL client time zone problem
Replies: 9
Views: 55623

Re: SQuirreL SQL client time zone problem

if you go on alias properties, and then select the driver properties... there is a property called 'connsettings', if i tick the specify box then I should be able to hardcode in a value. However i cant seem to type anything in the 'value' box, its just a drop down box with the value '?' Is it like t...
by circles85
Tue Jul 03, 2012 8:48 pm
Forum: SQuirreL SQL Client
Topic: SQuirreL SQL client time zone problem
Replies: 9
Views: 55623

Re: SQuirreL SQL client time zone problem

Thanks for the quick reply. I changed the URL to : jdbc:vertica://10.255.XX.XXX:5433/v_database?ConnSettings=SET TIMEZONE TO 'CET' and also jdbc:vertica://10.255.XX.XXX:5433/v_database?ConnSettings=SET TIMEZONE TO 'UTC' I then ran 'check timezone' and both times it changed the timezone successfully....
by circles85
Tue Jul 03, 2012 12:01 pm
Forum: SQuirreL SQL Client
Topic: SQuirreL SQL client time zone problem
Replies: 9
Views: 55623

SQuirreL SQL client time zone problem

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 sh...

Go to advanced search