[SQL] US Date Style - Mailing list pgsql-general

Hi people,

I'm having this problem with date fields. I'm using the Postgresql7.0beta4
and programming in PHP3. When I set the environment variable PGDATESTYLE
to "NonEuropean,SQL" it works, but only if I'm in the Pgsql environment.
When I access through the PHP3 it doesn't work.

Does anybody have any suggestion that could help me?

Thanks,
Gabriela.

On Thu, 20 Apr 2000, Jason Earl wrote:

> Thanks to <web Manager> and the PostgreSQL docs I have
> found out what I was doing wrong.  Actually the fix
> was so dead simple that I am more than a little
> embarrased to share.
>
> But here goes...
>
> The Debian package of PostgreSQL has a nifty
> configuration file /etc/postgresql/postmaster.init .
> Basically this file let's you customize just about any
> PostgreSQL parameter that is configurable at run time
> and worth fiddling with.  I read the config file and
> decided that setting:
>
> PGDATESTYLE=US
>
> Should do what I needed.  Unfortunately what I
> actually wanted was:
>
> PGDATESTYLE=POSTGRES
>
> Thanks to web@inter-resa.com, and special thanks to
> the PostgreSQL team for their continued efforts.
>
> 7.0 Rocks,
> Jason Earl
>
> --- Jason Earl <jdearl@yahoo.com> wrote:
> > 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
> >
>
> __________________________________________________
> Do You Yahoo!?
> Send online invitations with Yahoo! Invites.
> http://invites.yahoo.com
>