Default date format to ISO + 1 bug

From: Web Manager <web(at)inter-resa(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Default date format to ISO + 1 bug
Date: 2000-01-13 15:09:35
Message-ID: 387DEAAF.87986711@inter-resa.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

since I am a simple Postgres user, I don't understand the instruction to
change the postgresql default date format from 01-13-2000 to 2000-01-13

The timestamp format is OK with : 2000-01-13 09:11:24-05 but
Date gives : month-day-year

For Postgres v6.5 (and earlier) the default date/time style is
"non-European traditional Postgres" (I guess that means that timestamp
does not follow this default format). How do I change this?

And then... I have a second broblem:
I have postgres version 6.4.2

I created a new testing db.
createdb test
create table toto (num int2, name varchar(16), date_insc date);

When I : insert into toto values (1,'mapaquin',date('now'));
it give me : 1|mapaquin|12-31-1999

BUT IT IS JAN 13th !!!!!!

(yes, my PC has the rigth date!)

When I create a new table:
insert into toto2 (num int2, name varchar(16), date_insc timestamp
default now());

I make an insert: insert into toto values (1,'mapaquin');
it gives me: 1|mapaquin|2000-01-13 09:11:24-05

and now, it's OK!!!!

What is wrong?

Thank's!
--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Marc Andre Paquin

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jim Mercer 2000-01-13 15:39:52 Re: [GENERAL] Default date format to ISO + 1 bug
Previous Message admin 2000-01-13 14:22:34 Re: [GENERAL] searching oid's