Re: [SQL] Find rows with "timestamp out of range"

Поиск
Список
Период
Сортировка
От vinny
Тема Re: [SQL] Find rows with "timestamp out of range"
Дата
Msg-id a1996168394c6d8a702b4cf9160f177e@xs4all.nl
обсуждение исходный текст
Ответ на [SQL] Find rows with "timestamp out of range"  (Saiful Muhajir <saifulmuhajir@gmail.com>)
Ответы Re: [SQL] Find rows with "timestamp out of range"  (Saiful Muhajir <saifulmuhajir@gmail.com>)
Список pgsql-sql
On 2017-06-19 09:11, Saiful Muhajir wrote:
> Hi,
> 
> I have a table with around 133 MILLION ROWS with two timestamp
> columns. While trying to copy some columns for a new database, using
> \COPY , the error occurred with: TIMESTAMP OUT OF RANGE
> ​While trying to​ figure out the rows containing the out of range
> value, I am using this with no result:
> 

Are you sure that CREATED_AT is a timestamp? It seems odd that
the database would contain an invalid timestamp value in a timestamp 
field.



В списке pgsql-sql по дате отправления:

Предыдущее
От: Saiful Muhajir
Дата:
Сообщение: [SQL] Find rows with "timestamp out of range"
Следующее
От: Saiful Muhajir
Дата:
Сообщение: Re: [SQL] Find rows with "timestamp out of range"