date format problem

Поиск
Список
Период
Сортировка
От Bill Barnes
Тема date format problem
Дата
Msg-id 3910452E@operamail.com
обсуждение исходный текст
Список pgsql-general
Hello List:

Using 6.5.3 on SuSE 6.4.

Built a table with a date field as type 'datetime'.

I try to copy a text file to the table and get a 'bad date format'
Dates in the text file may be null, but are in the form 1997-12-15.
Have tried several of the date field types with the same result.
The copy executes properly if I redefine the date field to varchar.

Thanks for your help.
Bill Barnes

------------------------------------------------------------
This e-mail has been sent to  you  courtesy of OperaMail,  a
free  web-based  service  from  Opera  Software,  makers  of
the award-winning Web Browser - http://www.operasoftware.com
------------------------------------------------------------


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

Предыдущее
От: Maarten Boekhold
Дата:
Сообщение: Re: advice on indexing email
Следующее
От: frank
Дата:
Сообщение: plperl.so ?