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

How To Create DATETIME Data Types in A Table

From: "Van Ingen, Lane" <lvaningen(at)ESNCC(dot)com>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: How To Create DATETIME Data Types in A Table
Date: 2005-01-28 20:57:47
Message-ID: A3FF4275060B76459B5C08A64AE330C869E0@twmail.esncc.com (view raw or flat)
Thread:
Lists: pgsql-novice
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?

Responses

pgsql-novice by date

Next:From: John DeSoiDate: 2005-01-28 21:13:03
Subject: Re: How To Create DATETIME Data Types in A Table
Previous:From: Van Ingen, LaneDate: 2005-01-28 17:35:28
Subject: Re: Creating A Tablespace in PostgreSQL 8.0 for Windows

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