newbie Date question

From: Todd McGrath <toddmcgrath(at)yahoo(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: newbie Date question
Date: 2000-07-14 19:46:01
Message-ID: 20000714194601.13975.qmail@web705.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

I'm using 'copy from '/tmp/blah.csv' using delimiters
','; to import data from a file.

One field in this .csv file has a date. When I import
a field with 3/14/75 as the date it is fine
(1975-03-14), but when I import a date of 5/25/59 it
looks like 2059-05-25.

I'm running postgres 7.0 on RH6.2

Any way to change this?

-Todd

__________________________________________________
Do You Yahoo!?
Get Yahoo! Mail Free email you can access from anywhere!
http://mail.yahoo.com/

Browse pgsql-admin by date

  From Date Subject
Next Message Sandro Serafini 2000-07-18 07:53:24 postgresql user quota
Previous Message Neil Toronto 2000-07-14 17:07:20 Clustering (not indexes)