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!
>