Re: [SQL] Stalled post to pgsql-sql

2009-12-09 Thread Pavel Stehule
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:

Re: [SQL] Stalled post to pgsql-sql

2009-12-09 Thread sergey kapustin
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!