Default date format to ISO + 1 bug
От | Web Manager |
---|---|
Тема | Default date format to ISO + 1 bug |
Дата | |
Msg-id | 387DEAAF.87986711@inter-resa.com обсуждение исходный текст |
Ответы |
Re: [GENERAL] Default date format to ISO + 1 bug
Re: [GENERAL] Default date format to ISO + 1 bug |
Список | 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
В списке pgsql-general по дате отправления: