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

Set DateStyle not working

From: Dana Burd <DBurd(at)cpr(dot)org>
To: "'pgsql-interfaces(at)postgresql(dot)org'" <pgsql-interfaces(at)postgresql(dot)org>
Subject: Set DateStyle not working
Date: 2000-02-25 21:04:31
Message-ID: 893CF1EC58DAD211A2C00060089BB15D04C67A@COLORADO (view raw or flat)
Thread:
Lists: pgsql-interfaces
I am trying to get my output of a "timestamp" feild to look like "Wed Dec 17
07:37:16 1997 PST"

I have tried from a psql prompt the following:

cprn_apl=> SET DATESTYLE TO 'Postgres';
SET VARIABLE
cprn_apl=> select event_date from events;
event_date
----------------------
2000-04-05 04:34:00-06
2000-03-11 04:34:00-07
2000-03-02 14:23:00-07
2000-03-02 14:23:00-07
2000-06-18 14:23:00-06
2000-06-18 14:23:00-06
(6 rows)

cprn_apl=>

But as you can see, output is still set to 'ISO'.  
****I have also added the following line in my /etc/profile

PGDATESTYLE=Postgres

I logged out and back in.  At the linux prompt I can type 'set' and I can
see the 'PGDATESTYLE=Postgres' enviroment variable set.  But starting up
psql and doing the same select statement above gives me the same ISO output.

I don't even really want the output within psql to be Postgres, I really
just want it to be for the output for my web based application using Pg in
Perl.  I don't really know how to set variables for postgres (like
PGDATESTYLE) when there is no shell being invoked.  Once I can get atleast
psql to output what I want how can I get a output set for a web invoked
perl/cgi program or is that also simply set in the /etc/profile file as
well.

Thanks in advance
dburd(at)cpr(dot)org

pgsql-interfaces by date

Next:From: Ed LoehrDate: 2000-02-26 04:48:26
Subject: Re: [INTERFACES] Pgaccess - missing file, can't start
Previous:From: Don OliverDate: 2000-02-25 19:19:46
Subject: Pgaccess - missing file, can't start

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