Timestamp with time zone 'negative' problem
От | Prodan, Andrei |
---|---|
Тема | Timestamp with time zone 'negative' problem |
Дата | |
Msg-id | D33393149C01874DB3D72FE46A1B268B72C0A1@vpmail05-x.intra.ads-root.de обсуждение исходный текст |
Ответы |
Re: Timestamp with time zone 'negative' problem
|
Список | pgsql-general |
Hello, I have a DB in which items which are 'always valid' have a from_date of 19000101 000000+1 (Europe/Berlin) When i try to restore the same DB to (Europe/Bucharest), instead of 19000101 000000+2, the timestamp becomes "1900-01-01 00:44:24+01:44:24" which is ... strange. My software then complains (...correctly) that 01:44:24 is not a valid timezone. Am i doing something wrong, or should i report this to pg-bugs? Is there any way i can avoid this issue other than setting Timezone for the DB to (Europe/Berlin)? I am considering UPDATE on the rows to 1901 or some such... but that's a very gimmicky solution. Thank you, Andrei Prodan -------------------------------------------------- Awinta Consulting S.R.L. Canaluluistr. 44 505600 Sacele Brasov, Romania Tel. +40368 / 441024 Fax. +40368 / 441024 --------------------------------------------------
В списке pgsql-general по дате отправления: