Thread: Re: Stalled post to pgsql-sql

Hello,<br />I need a type that will store date and time, but without seconds and microseconds (like timestamp does). At
leastwithout microseconds.<br />I also need all the operators to work.<br />Is this possible with one of existing
date/timetypes or i need to create my own?<br /><br />Thank you!<br /> 

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