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

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 (view raw or flat)
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.

pgsql-general by date

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

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