Re: time stamp - Mailing list pgsql-admin

From Tom Lane
Subject Re: time stamp
Date
Msg-id 12748.1024591717@sss.pgh.pa.us
Whole thread Raw
In response to Re: time stamp  ("nimeshb" <nimeshb@syscon-intl.com>)
List pgsql-admin
"nimeshb" <nimeshb@syscon-intl.com> writes:
> CREATE TABLE test (ts TIMESTAMP WITHOUT TIME ZONE) ; doesn't work.

Oh?  I get

test72=# CREATE TABLE test (ts TIMESTAMP WITHOUT TIME ZONE) ;
CREATE
test72=# insert into test values(now());
INSERT 803798 1
test72=# insert into test values('2002-02-22 12:34:56');
INSERT 803799 1
test72=# select * from test;
             ts
----------------------------
 2002-06-20 12:46:47.030269
 2002-02-22 12:34:56
(2 rows)

test72=# select version();
                            version
---------------------------------------------------------------
 PostgreSQL 7.2.1 on hppa-hp-hpux10.20, compiled by GCC 2.95.3
(1 row)


            regards, tom lane

pgsql-admin by date:

Previous
From: "nimeshb"
Date:
Subject: Re: time stamp
Next
From: Felipe Nascimento
Date:
Subject: Re: time stamp