PostgreSQL 6.5.3 ignores date formatting settings ?

From: "Fabiano Ralo Monteiro" <howe(at)intercall(dot)com(dot)br>
To: <pgsql-general(at)postgresql(dot)org>
Subject: PostgreSQL 6.5.3 ignores date formatting settings ?
Date: 1999-12-28 06:33:31
Message-ID: 001201bf50fd$79708b30$62aac5c8@SAM
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi folks,

I'm using PostgreSQL on RH 6.1 aswell NT. In both I got strange behaviours with data formatting and locale settings.
Check this psql dump:

##########################################################
howe=> select version();
version
-------------------------------------------------------------------
PostgreSQL 6.5.3 on i586-pc-linux-gnu, compiled by gcc egcs-2.91.66
(1 row)
howe=> select now();
now
----------------------
1999-12-28 03:16:06-02
(1 row)

howe=> set datestyle to 'European';
SET VARIABLE
howe=> show datestyle;
NOTICE: DateStyle is Postgres with European conventions
SHOW VARIABLE
howe=> select now();
now
----------------------
1999-12-28 03:16:44-02
(1 row)

##########################################################

Shouldn't it have changed it's date style in the second "select now()" ?
The locale settings also seem to be completely ignored.

Best Regards,
Howe.

Browse pgsql-general by date

  From Date Subject
Next Message Marcin Mazurek - Multinet SA - Poznan 1999-12-28 07:33:34 RE: [GENERAL] Future of PostgreSQL
Previous Message Jeff Duska 1999-12-28 02:14:37 RE: [GENERAL] Future of PostgreSQL