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.
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 |