pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Jason Earl <jdearl@yahoo.com>
To: pgsql-sql@postgresql.org
Subject: US Date Style
Date: Thu, 20 Apr 2000 09:20:37 -0700 (PDT)
Message-ID: <20000420162037.10676.qmail@web119.yahoomail.com> (raw)

Note: I sent this to the pgsql-general list from
another account
yesterday, but it hasn't been answered.  My apologies
if you see it
twice.  On the other hand, I have taken some time to
proofread a bit,
so perhaps the punctuation won't be quite as bad.

I recently upgraded the PostgreSQL database on one of
my Debian Linux
boxes to postgresql-7.0-0.beta3-1 in preparation for
the grand
switchover to version 7.0.  So far I am quite
impressed, but I have
had a little bit of a problem setting the PGDATESTYLE
correctly.  For
historical reasons I would like to continue using the
US datestyle
(eg. Sat Jan 01 07:09:19 2000 MDT).

I have tried setting the variable in
/etc/postgresql/postmaster.init
and no joy.  I have also tried to set the value of
PGDATESTYLE
manually in psql using:

processdata=>\set PGDATESTYLE US

When I do this I am able to then check the variables
that are set and
I get:

processdata=> \set
VERSION = 'PostgreSQL 7.0.0 on i686-pc-linux-gnu,
compiled by gcc 2.95.2'
DBNAME = 'processdata'
USER = 'earlj'
HOST = 'nampadata'
PORT = '5432'
ENCODING = 'SQL_ASCII'
PROMPT1 = '%/%R%# '
PROMPT2 = '%/%R%# '
PROMPT3 = '>> '
HISTSIZE = '500'
PGDATESTYLE = 'US'

Unfortunately, when I test it out:

processdata=> select 'now'::datetime;
        ?column?        
------------------------
 2000-04-19 14:09:06-06
(1 row)

I still get the ISO format.  So what do I need to do
to get my US
datestyle back?

Sorry to bother,
Jason Earl


__________________________________________________
Do You Yahoo!?
Send online invitations with Yahoo! Invites.
http://invites.yahoo.com



view thread (8+ messages)  latest in thread

Message-ID: <20000420162037.10676.qmail@web119.yahoomail.com>
Permalink:  ../20000420162037.10676.qmail@web119.yahoomail.com/
Also on:    postgresql.org/message-id/20000420162037.10676.qmail@web119.yahoomail.com

 · 

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 from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-sql@postgresql.org
  Cc: jdearl@yahoo.com
  Subject: Re: US Date Style
  In-Reply-To: <20000420162037.10676.qmail@web119.yahoomail.com>
  References: <20000420162037.10676.qmail@web119.yahoomail.com>

* 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