pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Mark Fenbers <Mark.Fenbers@noaa.gov>
To: PostgreSQL - SQL <pgsql-sql@postgresql.org>
Subject: Change date format through an environmental variable?
Date: Wed, 01 Mar 2006 12:32:26 -0500
Message-ID: <4405DAAA.4010908@noaa.gov> (raw)

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



view thread (10+ messages)  latest in thread

Message-ID: <4405DAAA.4010908@noaa.gov>
Permalink:  ../4405DAAA.4010908@noaa.gov/
Also on:    postgresql.org/message-id/4405DAAA.4010908@noaa.gov

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: Mark.Fenbers@noaa.gov
  Subject: Re: Change date format through an environmental variable?
  In-Reply-To: <4405DAAA.4010908@noaa.gov>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox