Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pdxpug by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group