From: Jason Earl <jdearl@yahoo.com>
To: pgsql-sql@postgresql.org
Subject: Re: US Date Style
Date: Thu, 20 Apr 2000 09:42:59 -0700 (PDT)
Message-ID: <20000420164259.20124.qmail@web107.yahoomail.com> (raw)
With a little bit of grepping through the docs I have
found something that will mostly work for me. I
simply need to have each client issue a:
SET DATESTYLE TO 'Postgres';
This works just fine, but (of course) I would rather
have this set up as the 'default.' Does anyone know
how to do this?
Thanks again,
Jason
--- Jason Earl <jdearl@yahoo.com> wrote:
> 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
>
__________________________________________________
Do You Yahoo!?
Send online invitations with Yahoo! Invites.
http://invites.yahoo.com
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: <20000420164259.20124.qmail@web107.yahoomail.com>
References: <20000420164259.20124.qmail@web107.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