NZDT Question
От | Mike C |
---|---|
Тема | NZDT Question |
Дата | |
Msg-id | bd0eabd0709251952x1bbfd54do2b099812ade9abe3@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: NZDT Question
|
Список | pgsql-general |
Hi, I've just upgraded from Postgres 8.1.0 to 8.1.10 to update the NZ timezone changes, but it doesn't seem to make a difference (I've also patched linux). Ideas? Below is how I'm testing (artificially set time into future): -bash-3.1$ date Mon Oct 1 07:12:36 NZDT 2007 -bash-3.1$ psql test Welcome to psql 8.1.10, the PostgreSQL interactive terminal. Type: \copyright for distribution terms \h for help with SQL commands \? for help with psql commands \g or terminate with semicolon to execute query \q to quit business=# select now(); now ------------------------------- 2007-10-01 06:12:40.097244+12 (1 row) business=# select current_timestamp; now ------------------------------- 2007-10-01 06:12:43.697349+12 (1 row) Note the 1 hour difference between postgres and date. Regards, Mike
В списке pgsql-general по дате отправления: