From: | "Anand Raman" <araman(at)india-today(dot)com> |
---|---|
To: | "Bill Barnes" <bbarnes(at)operamail(dot)com>, <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: date format problem |
Date: | 2000-05-03 05:35:32 |
Message-ID: | 01b201bfb4c1$66105f20$2203a8c0@harry |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)operamail(dot)com>
To: <pgsql-general(at)postgresql(dot)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
> ------------------------------------------------------------
>
From | Date | Subject | |
---|---|---|---|
Next Message | surfer girl | 2000-05-03 06:13:14 | Re: OID output problems |
Previous Message | Anand Raman | 2000-05-03 04:17:28 | Re: [GENERAL] postgresql7.0 jdbc driver |