Re: Stalled post to pgsql-sql

hello
postgres=# create table foo(a timestamp(0));
CREATE TABLE
Time: 111,105 ms
postgres=# insert into foo values(now());
INSERT 0 1
Time: 1,292 ms
postgres=# select now(), a from foo;             now              |          a
-------------------------------+---------------------2009-12-09 11:33:22.746217+01 | 2009-12-09 11:33:12
(1 row)

Time: 21,010 ms

regards
Pavel Stehule


2009/12/9 sergey kapustin <kapustin.sergey@gmail.com>:
> Hello,
> I need a type that will store date and time, but without seconds and
> microseconds (like timestamp does). At least without microseconds.
> I also need all the operators to work.
> Is this possible with one of existing date/time types or i need to create my
> own?
>
> Thank you!
>