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: (view raw, whole thread or download thread mbox)
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?


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-2017 The PostgreSQL Global Development Group