Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 736586322A8 for ; Wed, 9 Dec 2009 06:30:56 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 89679-09 for ; Wed, 9 Dec 2009 10:30:48 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-ew0-f213.google.com (mail-ew0-f213.google.com [209.85.219.213]) by mail.postgresql.org (Postfix) with ESMTP id 7C87A63220C for ; Wed, 9 Dec 2009 06:30:48 -0400 (AST) Received: by ewy5 with SMTP id 5so1603027ewy.34 for ; Wed, 09 Dec 2009 02:30:46 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:sender:received:in-reply-to :references:date:x-google-sender-auth:message-id:subject:from:to :content-type; bh=+1T8I5i4U4E7Y3IDRCGSKpq7hbE25DXKiCAB6uoypaM=; b=O12VT2YabLRic4tb0Ckuvtyvan+hLQs7DW9xbfYmWOnYLAApLHsQM02/O0D7Ll9Xjw 1SQM7J2oZu+k/7c8QbRlflWG+t9fxAUOdwuwMzvOFIwevrLgcWrL1nVqGmLyHqxlBiDA GVE3Yl/MXOwWrgWbeu5H9gLQUqhh05WK5lzB4= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:sender:in-reply-to:references:date :x-google-sender-auth:message-id:subject:from:to:content-type; b=esNDrvj6WCeqIn7xRGBnWmjLHedUmEN0l6lFETRdc4O2nORjoKcd/Y+iOT8FwffAYG OYjsVaNaLzIyj3xlC7HilcfOClR3oFPFk+ihQCoqaHplf+34zxatzVYZOtJ2blkMyImC 7oSgM0Mcr00wJdQs88LTcH8shVl4zRxJIPEB0= MIME-Version: 1.0 Received: by 10.213.15.14 with SMTP id i14mr10443230eba.50.1260354644340; Wed, 09 Dec 2009 02:30:44 -0800 (PST) In-Reply-To: References: Date: Wed, 9 Dec 2009 12:30:44 +0200 X-Google-Sender-Auth: 7855382fb15c720b Message-ID: Subject: Re: Stalled post to pgsql-sql From: sergey kapustin To: pgsql-sql@postgresql.org Content-Type: multipart/alternative; boundary=0015174bdcb6ddf2a9047a492e3f X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.109 tagged_above=-10 required=5 tests=BAYES_05=-1.11, HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200912/21 X-Sequence-Number: 33459 --0015174bdcb6ddf2a9047a492e3f Content-Type: text/plain; charset=ISO-8859-1 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! --0015174bdcb6ddf2a9047a492e3f Content-Type: text/html; charset=ISO-8859-1 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!
--0015174bdcb6ddf2a9047a492e3f--