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

changing datestyle

From: Thomas Good <tomg(at)q8(dot)nrnet(dot)org>
To: pgsql-novice(at)hub(dot)org
Subject: changing datestyle
Date: 2000-10-30 16:12:53
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
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: Jason DavisDate: 2000-10-30 23:03:04
Subject: Re: changing datestyle
Previous:From: James HallDate: 2000-10-30 15:54:30
Subject: Postgres not finding tables

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