Re: to_date

On Mon, 2006-02-13 at 15:22, Jim Fu wrote:
> Thank you Michael for the info!
>
> I have the original date info as mmddyy, when I use copy tabname from filename, it fails due to mismatch between raw
dateinfo and date data type in the database. It seems like I had to convert the raw date info to be like 'yyyy-mm-dd'
tomatch PostgreSQL date default format in order to use copy command. 


Take a look here:

http://www.postgresql.org/docs/8.1/static/runtime-config-client.html#GUC-DATESTYLE
and here:
http://www.postgresql.org/docs/8.1/static/datatype-datetime.html