invalid abstime to timestamp error only on specific date range
От | zhong ming wu |
---|---|
Тема | invalid abstime to timestamp error only on specific date range |
Дата | |
Msg-id | m2p9e434c4d1004270414v4b21bbe1maece52369eb648c6@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: invalid abstime to timestamp error only on specific date range
|
Список | pgsql-general |
I have a postgres table with a column type abstime. (all data in this database are loaded from an ancient propriety database) When I filter data from this table with a specific date range on this column it works. When I filter with a different date range it gives me an error like invalid abstime to timestamp I don't have that server at this moment and I cannot post exact error. I'll if I have to. I was pulling my hair out because it happens only with a specific date range and can't be my invalid format in select statement. Say i do psql> select * from shipping where ship_date <= '04/22/2008' and ship_date>='04/21/2008' it works but if i do psql> select * from shipping where ship_date <= '04/22/2010' and ship_date>='04/21/2010' it won't even perform the query but emits the error. Both server and client are 8.4.3 I tried other date formats but above format should work because it works with 2008 year. Thanks for any suggestion
В списке pgsql-general по дате отправления: