]
*Sent:* Wednesday, June 18, 2014 10:25 AM
*To:* Burdett, Neil (CCI, Herston - RBWH)
*Cc:* galaxy-dev@lists.bx.psu.edu
*Subject:* Re: [galaxy-dev] Postgresql database time wrong...
Postgres generally stores datatime fields in GMT, and then translates
them to the local time zone when
Hi
I have quite a strange issue. I have a local install of Galaxy setup. When I
type 'date' on my Ubuntu machine I get something like:
Wed Jun 18 09:25:22 EST 2014
When i then execute a job and look in the database at the create_time i.e.
# select create_time from job order by create_time;
Postgres generally stores datatime fields in GMT, and then translates them
to the local time zone when generating a query. Check the TimeZone variable
in your postgres.conf.
http://www.postgresql.org/docs/9.3/static/datatype-datetime.html#DATATYPE-TIMEZONES
-Will
On Tue, Jun 17, 2014 at 4:29
- RBWH)
Cc: galaxy-dev@lists.bx.psu.edu
Subject: Re: [galaxy-dev] Postgresql database time wrong...
Postgres generally stores datatime fields in GMT, and then translates them to
the local time zone when generating a query. Check the TimeZone variable in
your postgres.conf.
http