From: | "Sangeeta Rao" <Sangeeta_Rao(at)mw(dot)3com(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org, pgsql-interfaces(at)postgresql(dot)org |
Subject: | Set DATESTYLE='ISO' (Postgres 6.3.2) |
Date: | 1998-08-24 21:41:12 |
Message-ID: | 8625666A.00731387.00@mwgate02.mw.3com.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-interfaces |
Hi,
I am using Postgresql 6.3.2 and would like to set the datestyle to be ISO.
Here is what I did:
- issued "set datestyle='ISO' " using PQexec() after opening a connection
with the database. (no errors)
- Then checked the datestyle from psql
dbxxx=> show datestyle ;
response:
NOTICE: DateStyle is Postgres with US (NonEuropean) conventions.
- Also, when I open a jdbc connection with debug tracing on I notice that
the datestyle is Postgres
Why so?? Is this a bug or am I missing something?
Instead of issuing 'set datestyle' command if I set the environment
variable
'PGDATESTYLE' to ISO it works fine but I would like to avoid having to do
this.
What do I need to do to get the sql command 'set datestyle' to work??
I appreciate any help.
Thank You,
SR
From | Date | Subject | |
---|---|---|---|
Next Message | Cho Yan Wong | 1998-08-25 02:17:45 | copy probs |
Previous Message | Thomas Good | 1998-08-24 20:59:56 | Re: [GENERAL] DBD::Pg |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 1998-08-24 21:52:20 | Re: [INTERFACES] Re: [HACKERS] Convert PGconn, PGresult to opaque types? |
Previous Message | John Sharp | 1998-08-24 18:44:00 | postgresql for sparc 2.5.1? |