Re: [GENERAL] datetime datatype question - Mailing list pgsql-general

From Patrick Welche
Subject Re: [GENERAL] datetime datatype question
Date
Msg-id E11YApU-0003gn-00@quartz.newn.cam.ac.uk
Whole thread Raw
List pgsql-general
Kevin Heflin wrote:
>
> On Fri, 1 Oct 1999, Patrick Welche wrote:
>
> > rfb=> \h set
> > Command: set
> > Description: set run-time environment
> > Syntax:
> >         SET DATESTYLE TO 'ISO'|'SQL'|'Postgres'|'European'|'US'|'NonEuropean'
> >
> > it looks like
> >
> > set datestyle to 'ISO'
>
> Yes, that's what I was looking for. Thanks.
>
> Changing the datestyle like this, is only good for the current
> connection.. ?

I think so, but setting the environment variable would work for all
new connections from the client which has that variable set. (eg in csh
setenv PGDATESTYLE ISO
)

Cheers,

Patrick

pgsql-general by date:

Previous
From: Joe Devlin
Date:
Subject: [PHP3] mysql-unsubscribe@lists.mysql.com
Next
From: Joe Devlin
Date:
Subject: mysql-unsubscribe@lists.mysql.com