Re: date format problem
От | Anand Raman |
---|---|
Тема | Re: date format problem |
Дата | |
Msg-id | 01b201bfb4c1$66105f20$2203a8c0@harry обсуждение исходный текст |
Ответ на | date format problem (Bill Barnes <bbarnes@operamail.com>) |
Список | pgsql-general |
HI bill Try to cast the field to the datetime type 'ur_string_goes_here'::datetime Hope this will help Anand Raman ----- Original Message ----- From: Bill Barnes <bbarnes@operamail.com> To: <pgsql-general@postgresql.org> Sent: Friday, April 28, 2000 6:09 PM Subject: [GENERAL] date format problem > 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 по дате отправления: