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 по дате отправления: