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 PM, <neil.burd...@csiro.au> wrote: > 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; > > I get > > 2014-06-17 23:20:00.133828 > > So about 10 hours different. Is there some configuration I need to set as > Brisbane is 10hrs ahead of GMT (coincidence?) > > Thanks > Neil > > ___________________________________________________________ > Please keep all replies on the list by using "reply all" > in your mail client. To manage your subscriptions to this > and other Galaxy lists, please use the interface at: > http://lists.bx.psu.edu/ > > To search Galaxy mailing lists use the unified search at: > http://galaxyproject.org/search/mailinglists/ >
___________________________________________________________ Please keep all replies on the list by using "reply all" in your mail client. To manage your subscriptions to this and other Galaxy lists, please use the interface at: http://lists.bx.psu.edu/ To search Galaxy mailing lists use the unified search at: http://galaxyproject.org/search/mailinglists/
