Re: date format

From: Martijn van Oosterhout <kleptog(at)svana(dot)org>
To: Garry Saddington <garry(at)schoolteachers(dot)co(dot)uk>
Cc: pgsql-general(at)postgresql(dot)org, rod(at)iol(dot)ie
Subject: Re: date format
Date: 2007-03-04 17:09:35
Message-ID: 20070304170935.GC11685@svana.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sun, Mar 04, 2007 at 05:05:44PM +0000, Garry Saddington wrote:
> On Sunday 04 March 2007 16:16, Raymond O'Donnell wrote:
> > On 04/03/2007 16:16, Garry Saddington wrote:
> > > I tried pgAdmin3 on windows to run 'select now()' and it still does not
> > > return the correct datestyle.
> >
> > Probably a silly question, but did you remember to restart the server
> > after changing the datestyle setting?
> yes
> regards

Can you show us your exact output so we don't have to guess? I get
this:

# set datestyle=iso,dmy;
SET
# select now();
now
-------------------------------
2007-03-04 18:07:54.626267+01
(1 row)

Which is precisely what I expect.

Have a nice day,
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Eddy D. Sanchez 2007-03-04 18:17:51 pljava on mac
Previous Message Garry Saddington 2007-03-04 17:05:44 Re: date format