Re: Timestamp Error - 7.2

Поиск
Список
Период
Сортировка
От Josh Berkus
Тема Re: Timestamp Error - 7.2
Дата
Msg-id web-1660268@davinci.ethosmedia.com
обсуждение исходный текст
Ответ на Timestamp Error - 7.2  (Keith Gray <keith@heart.com.au>)
Список pgsql-sql
Keith,

> We have moved from 7.1 to 7.2 and get the following error when
> extracting dates.
> 
> Bad timestamp external representation ' '
> 
> 
> eg. INSERT INTO mytable VALUES('1', '2001-09-24')

The error, as you have described it, is highly unlikely.   You will
need to provide more information if you still want help. Please:

1. Post table defintions.
2. Post your *actual* SQL statements which trigger the error, not
example ones which you have nto actually tested.

-Josh Berkus


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

Предыдущее
От: Dmitry Tkach
Дата:
Сообщение: Re: Is there a better way than this to get the start and end of a month?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Getting current transaction id