Re: [HACKERS] Can't import date using copy

2000-10-27 Thread Tom Lane
Guy Fraser <[EMAIL PROTECTED]> writes: > I have tried reformatting dates in many ways but every thing I have > tried fails. As a rule, COPY will interpret incoming dates according to the current setting of the DATESTYLE variable. It'd help if you explained the date format you are trying to read

Re: [HACKERS] Can't import date using copy

2000-10-27 Thread Stephan Szabo
On Fri, 27 Oct 2000, Guy Fraser wrote: > Hi > > I have tried reformatting dates in many ways but every thing I have > tried fails. I've been able to use copy to import date values in a simple test: create table dt (a date); copy dt from stdin; 01-12-2000 12-11-1999 \. put the date values in fi