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

datestyle

From: pgsql-bugs(at)postgresql(dot)org
To: pgsql-bugs(at)postgresql(dot)org
Subject: datestyle
Date: 2000-09-09 08:19:09
Message-ID: 200009090819.e898J9f30147@hub.org (view raw or flat)
Thread:
Lists: pgsql-bugs
Bruno LEVEQUE (bruno(dot)leveque(at)libertysurf(dot)fr) reports a bug with a severity of 2
The lower the number the more severe it is.

Short Description
datestyle

Long Description
I use postgresql 7.0.2 under Linux (slackware 7.1)
I cannot change the format of the date style with set
I'm French and I want to use the European format i.e : DD/MM/YYYY and not YYYY/MM/DD

Sample Code
create table anyname (
philippe1(# myDate date);
CREATE
philippe1=# show datestyle;
NOTICE:  DateStyle is ISO with US (NonEuropean) conventions
SHOW VARIABLE
philippe1=# set datestyle to 'European';
SET VARIABLE
philippe1=# show datestyle;
NOTICE:  DateStyle is ISO with European conventions
SHOW VARIABLE
philippe1=# insert into anyname values('31/12/2000');
INSERT 114889 1
philippe1=# select * from anyname;
   mydate   
------------
 2000-12-31
(1 row)



No file was uploaded with this report


Responses

pgsql-bugs by date

Next:From: Stephan SzaboDate: 2000-09-09 16:43:31
Subject: Re: Backend crash trying to delete rows
Previous:From: pgsql-bugsDate: 2000-09-09 06:29:44
Subject: Backend crash trying to delete rows

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