Change date format through an environmental variable?

From: Mark Fenbers <Mark(dot)Fenbers(at)noaa(dot)gov>
To: PostgreSQL - SQL <pgsql-sql(at)postgresql(dot)org>
Subject: Change date format through an environmental variable?
Date: 2006-03-01 17:32:26
Message-ID: 4405DAAA.4010908@noaa.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

I want to get Pg (v7.4.7) to output a date field in a different format
than yyyy-mm-dd through the use of an environmental variable (because I
have no access the SQL). Is this possible? I know about the DATESTYLE
variable, but that seems to work only within a query transaction, and
has no effect if trying to set it as an envvar.

Mark

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Bryce Nesbitt 2006-03-01 17:51:46 Replication - state of the art?
Previous Message Mark Dilger 2006-03-01 17:05:09 Re: [SQL] Interval subtracting