Re: date format problem - Mailing list pgsql-general

From Anand Raman
Subject Re: date format problem
Date
Msg-id 01b201bfb4c1$66105f20$2203a8c0@harry
Whole thread Raw
In response to date format problem  (Bill Barnes <bbarnes@operamail.com>)
List 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 by date:

Previous
From: surfer girl
Date:
Subject: Re: OID output problems
Next
From: Bill Barnes
Date:
Subject: RE: date format problem