Re: [Squirrel-sql-users] SQuirreL SQL client time zone problem

[Robert M. <rob...@gm...>]

It might help to let us know which database you are using.

Rob

On Tue, Jul 3, 2012 at 6:56 AM, Jai Sumaria <Jai...@ka...> wrote:

>  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.
>
>
> ------------------------------------------------------------------------------
> Live Security Virtual Conference
> Exclusive live event will cover all the ways today's security and
> threat landscape has changed and how IT managers can respond. Discussions
> will include endpoint security, mobile security and the latest in malware
> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>
>