| From: | "Patrick Welche" <prlw1(at)newn(dot)cam(dot)ac(dot)uk> |
|---|---|
| To: | kheflin(at)shreve(dot)net (Kevin Heflin) |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: [GENERAL] datetime datatype question |
| Date: | 1999-10-04 16:19:12 |
| Message-ID: | E11YApU-0003gn-00@quartz.newn.cam.ac.uk |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Nikos Mouat | 1999-10-04 17:04:41 | |
| Previous Message | Joe Devlin | 1999-10-04 16:05:16 | mysql-unsubscribe@lists.mysql.com |