Re: now() time off

From: "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com>
To: Michael Fuhr <mike(at)fuhr(dot)org>
Cc: Scott Marlowe <smarlowe(at)g2switchworks(dot)com>, John McCawley <nospam(at)hardgeus(dot)com>, pgsql general <pgsql-general(at)postgresql(dot)org>
Subject: Re: now() time off
Date: 2006-02-23 23:36:18
Message-ID: 20060223233618.GL2068@pervasive.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Feb 23, 2006 at 03:49:50PM -0700, Michael Fuhr wrote:
> On Thu, Feb 23, 2006 at 04:21:19PM -0600, Jim C. Nasby wrote:
> > On Thu, Feb 23, 2006 at 12:41:38PM +0100, Martijn van Oosterhout wrote:
> > > Alternativly you could just set the "timezone" parameter in the
> > > postgresql configuration...
> >
> > Wow, didn't know that was there... was it added fairly recently or have
> > I just been blind?
>
> http://www.postgresql.org/docs/7.3/interactive/release-7-3.html
>
> "Add configuration variables datestyle and timezone (Tom)"

Whew. I started on 7.2, so I have a bit of an excuse. :)
--
Jim C. Nasby, Sr. Engineering Consultant jnasby(at)pervasive(dot)com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461

In response to

Browse pgsql-general by date

  From Date Subject
Next Message elein 2006-02-24 00:02:50 Re: Temporal Databases
Previous Message Jim C. Nasby 2006-02-23 23:25:12 Re: subtracting minutes from date