Postgres Pro
Downloads
Home   >   mailing lists

How To Create DATETIME Data Types in A Table - Mailing list pgsql-novice

From Van Ingen, Lane
Subject How To Create DATETIME Data Types in A Table
Date
Msg-id A3FF4275060B76459B5C08A64AE330C869E0@twmail.esncc.com
Whole thread Raw
Responses Re: How To Create DATETIME Data Types in A Table  (John DeSoi <desoi@pgedit.com>)
Re: How To Create DATETIME Data Types in A Table  (Bruno Wolff III <bruno@wolff.to>)
List pgsql-novice
Tree view 
I am converting several databases from difference database vendors in PostgreSQL, but I am
finding that PostgreSQL appears to not support this datatype, unlike the other vendors we use.
The DATETIME fields coming from the other databases look like:
     '2005-01-27 15:55:04'
How do I get the same effect in Postgres CREATE TABLE statement without losing data?

pgsql-novice by date:

Previous
From: "Van Ingen, Lane"
Date:
Subject: Re: Creating A Tablespace in PostgreSQL 8.0 for Windows
Next
From: John DeSoi
Date:
Subject: Re: How To Create DATETIME Data Types in A Table