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

On Fri, Jan 28, 2005 at 15:57:47 -0500,
  "Van Ingen, Lane" <lvaningen@ESNCC.com> wrote:
> 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?

In postgres you want to use timestamp with time zone. (Or perhaps timestamp
without time zone, depending on what the timestamp represents.)