Skip site navigation (1) Skip section navigation (2)

changing datestyle

From: "Karl Nack" <karlnack(at)futurityinc(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: changing datestyle
Date: 2009-06-16 05:53:00
Message-ID: 1245131580.v2.mailanyonewebmail-389065@fuse114 (view raw, whole thread or download thread mbox)
Lists: 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.

Karl Nack Futurity, Inc.773-506-2007


pgsql-novice by date

Next:From: Bruce HyattDate: 2009-06-16 13:42:07
Subject: Re: Fwd: Yum Update Errors
Previous:From: TimDate: 2009-06-16 01:08:46
Subject: Fwd: Yum Update Errors

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group