timestamp and input format

From: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
To: pdxpug(at)postgresql(dot)org
Subject: timestamp and input format
Date: 2011-02-18 17:02:10
Message-ID: alpine.LNX.2.00.1102180857550.30932@salmo.appl-ecosys.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pdxpug

Wes was kind enough to load the large database into Access and export a
.csv file. Now I can clean the data and table schema and move on to using
the data.

Reading Section 8.5.1 (Date/Time Imput) of the on-line 9.x manual suggests
that I can leave the date data in its original format, i.e., 7/1/1947
0:00:00. Is this correct?

If I specify the column data type as DATE rather than TIMESTAMP, will the
immaterial time portion be dropped when the file is copied into the table?

Rich

Browse pdxpug by date

  From Date Subject
Next Message Rich Shepard 2011-02-23 23:34:52 Changing the Primary Key Column
Previous Message Rich Shepard 2011-02-17 16:03:49 Re: SQLite to Postgres, II