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