Its possible that the driver might be doing this. Take a look at the
vertica driver documentation to see if there is a driver property to
configure this behavior. If there is, you can add a driver property to the
alias by selecting the alias and choosing "Alias Properties".
Rob
On Wed, Mar 21, 2012 at 3:13 PM, Kreutzer, Ted <Ted...@mt...>wrote:
> Currently, I am using Squirrel SQL with a Vertica DB cluster. When I
> run queries that involve a return of timestamp values with a timezone,
> instead of the UTC value stored on the server, Squirrel SQL converts the
> timestamp value to the timezone of my client (Pacific).
>
> Is there are setting, configuration, or workaround so that I can get the
> UTC timezone instead of the client timezone.
>
> --
>
> *Ted Kreutzer* | Database Architect |
> Nickelodeon | Social Games
>
>
> ------------------------------------------------------------------------------
> This SF email is sponsosred by:
> Try Windows Azure free for 90 days Click Here
> http://p.sf.net/sfu/sfd2d-msazure
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>
>
|