| 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: | Whole Thread | Raw Message | 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 |