changing datestyle - Mailing list pgsql-novice

From Karl Nack
Subject changing datestyle
Date
Msg-id 1245131580.v2.mailanyonewebmail-389065@fuse114
Whole thread Raw
Responses Re: changing datestyle
List pgsql-novice
This is driving me a little nuts.

SET datestyle = 'us';
ALTER DATABASE mydb SET datestyle = 'us';
ALTER USER me SET datestyle = 'us';

In postgresql.conf:
datestyle = 'us'

And yet datestyle continues to come back as 'ISO, MDY'.

Re-doing all this using 'MDY, MDY' doesn't work either.

I don't much care about the input format, since postgres is pretty
flexible, but it'd sure be nice to get m/d/y out without having to
manually convert it in all my queries.

What am I missing?

If it helps, I'm running 8.3.7 on Debian Lenny.

Thanks.
Karl Nack Futurity, Inc.773-506-2007


pgsql-novice by date:

Previous
From: Tim
Date:
Subject: Fwd: Yum Update Errors
Next
From: Bruce Hyatt
Date:
Subject: Re: Fwd: Yum Update Errors