timestamp resolution? - Mailing list pgsql-hackers

From Tatsuo Ishii
Subject timestamp resolution?
Date
Msg-id 20011004135111R.t-ishii@sra.co.jp
Whole thread Raw
List pgsql-hackers
Is this an expected behavior? I could not see why t1 and t2 are
showing different time resolutions...

test=# create table t3(t1 timestamp(2), t2 timestamp(2) default current_timestamp);
CREATE
test=# insert into t3 values(current_timestamp);
INSERT 16566 1
test=# select * from t3;          t1           |            t2             
------------------------+---------------------------2001-10-04 13:48:34+09 | 2001-10-04 13:48:34.34+09
(1 row)

--
Tatsuo Ishii


pgsql-hackers by date:

Previous
From: Thomas Lockhart
Date:
Subject: Re: BUG: text(varchar) truncates at 31 bytes
Next
From: Thomas Lockhart
Date:
Subject: Re: timestamp resolution?