Datestyle and Postmaster

From: Jason Everett <jeverett(at)esu10(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: Datestyle and Postmaster
Date: 2000-11-16 18:47:23
Message-ID: 3A142BBB.BD2865E6@esu10.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Greetings,

I have upgraded Postgres to v7.0.3 on a linux machine and have run into
some trouble. I am using a very old program that I didn't write but it
is having some trouble with the way Postgres is handling the date. It
would be easiest for me to have Postgres handle the date in this format:
MM-DD-YYYY.

Is it possible to have postmaster control the datestyle other than -e
for the European style? I have gotten "SET DATESTYLE TO 'SQL, US'" to
work using psql but I'm not quite sure how to get my programs to do the
same (other than rewrite them to use the ISO, US style). Is there a way
I could use the -o option in postmaster?

Is there a function I could call that I could use to change this behavior?

What version of postgres supported MM-DD-YYYY as the default? Does
v.6.5.3 have this behavior? If so, I do have a copy of this with my
data in this format.

Thanks for your help,
Jason

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Marc SCHAEFER 2000-11-16 19:08:27 Re: Datestyle and Postmaster
Previous Message Karl DeBisschop 2000-11-16 18:45:36 Re: [HACKERS] Re: PHPBuilder article -- Postgres vs MySQL