Skip site navigation (1) Skip section navigation (2)

Re: changing datestyle

From: Jason Davis <jdavis(at)tassie(dot)net(dot)au>
To: Thomas Good <tomg(at)q8(dot)nrnet(dot)org>
Cc: pgsql-novice(at)hub(dot)org
Subject: Re: changing datestyle
Date: 2000-10-30 23:03:04
Message-ID: (view raw or whole thread)
Lists: pgsql-novice

I had the same problem with my web database stuff. The trick is to put the


in your apache.conf (assuming you are running apache). Seems to be fussy
where it goes - works if you put it directly above the User and Group

A postmaster restart will be necessary.


Jason Davis
Database Administrator/Programmer
Tas Access

At 11:12 AM 30/10/2000 -0500, you wrote:
>Hi all.
>This ISO datestyle is a nuisance.  In my /etc/profile I am exporting
>an env var:  export PGDATESTYLE='postgres'
>This converts the date back to what ppl here are used to...but it
>does not work for the web server and the nobody user.
>Do I have to manually SET the variable before every SELECT ???
>Geez, I hope not...
>               SVCMC - Center for Behavioral Health                  
>Thomas Good                          tomg@ { admin | q8 }
>IS Coordinator / DBA                 Phone: 718-354-5528 
>                                     Fax:   718-354-5056  
>Powered by:  PostgreSQL     s l a c k w a r e          FreeBSD:
>               RDBMS       |---------- linux      The Power To Serve

In response to


pgsql-novice by date

Next:From: andrea gelminiDate: 2000-10-31 07:46:54
Subject: ehm... drop column...
Previous:From: Thomas GoodDate: 2000-10-30 16:12:53
Subject: changing datestyle

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group