extract epoch bug
От | olav@venus.jordforsk.no (Hans Olav Eggestad) |
---|---|
Тема | extract epoch bug |
Дата | |
Msg-id | 20050704220506.2805A36B@venus.jordforsk.no обсуждение исходный текст |
Ответы |
Re: extract epoch bug
Re: extract epoch bug |
Список | pgsql-bugs |
I've just installed v8.0.3 and tested the 'epoch' part of extract, which for my applications is fundamental. here is the result: jova=# select extract(epoch from timestamp '19700102')\g date_part ----------- 82800 (1 row) jova=# select extract(epoch from timestamp '19700101')\g date_part ----------- -3600 (1 row) jova=# select extract(epoch from timestamp with time zone '19700101')\g date_part ----------- -3600 (1 row) jova=# select extract(epoch from timestamp without time zone '19700101')\g date_part ----------- -3600 (1 row) the time zone here is 1 hour before GMT, so i guess it has something to do with that, but i have to have this function correct.hope i can get a patch for this soon. (BTW i've not tested this in earlier versions, but i'm now going to make posgresversion of my sybase applications)
В списке pgsql-bugs по дате отправления: