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