On 22 February 2012 16:50, Peter van Hardenberg <[email protected]> wrote:
>
>
> Take a look at SET TIME ZONE. We're aware of the problem, and the new
> shared databases in beta today shouldn't have it.
>
> http://www.postgresql.org/docs/8.1/static/sql-set.html
>
>
Hi Peter, thanks for the response.
I tried the following but it appears that it didn't change the setting:
SQL> select current_setting('timezone');
+-----------------+
| current_setting |
+-----------------+
| localtime |
+-----------------+
SQL> SET timezone TO 'UTC';
OK
SQL> select current_setting('timezone');
+-----------------+
| current_setting |
+-----------------+
| localtime |
+-----------------+
I also tried on my local box and it did work - is there anything else I
need to do first?
Regards,
Iain
--
You received this message because you are subscribed to the Google Groups
"sequel-talk" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/sequel-talk?hl=en.
