Thread: Re: [GENERAL] datetime datatype question

Re: [GENERAL] datetime datatype question

From
"Patrick Welche"
Date:
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