X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id C74409DCA66 for ; Tue, 20 Dec 2005 08:59:12 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 73116-01 for ; Tue, 20 Dec 2005 08:59:15 -0400 (AST) Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 909FC9DCA5B for ; Tue, 20 Dec 2005 08:59:10 -0400 (AST) Received: from smtp20.kymp.net (smtp20.kymp.net [80.248.96.137]) by svr4.postgresql.org (Postfix) with ESMTP id 5A45B5AF06A for ; Tue, 20 Dec 2005 12:59:13 +0000 (GMT) Received: from [192.168.0.100] (static-241-66.kymp.net [213.130.241.66]) by smtp20.kymp.net (8.13.3/8.13.3) with SMTP id jBKCx7Pb020716 for ; Tue, 20 Dec 2005 14:59:08 +0200 From: Aarni =?iso-8859-1?q?Ruuhim=E4ki?= Reply-To: aarni@kymi.com Organization: KYMI.com To: pgsql-sql@postgresql.org Subject: Querying date_time for date only ? Date: Tue, 20 Dec 2005 14:59:07 +0200 User-Agent: KMail/1.6.2 MIME-Version: 1.0 Content-Disposition: inline Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Message-Id: <200512201459.07358.aarni@kymi.com> X-Virus-Scanned: by amavisd-new X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.333 required=5 tests=[AWL=0.333] X-Spam-Score: 0.333 X-Spam-Level: X-Archive-Number: 200512/172 X-Sequence-Number: 23714 Hello List, I have a time stamp without time zone field, YYYY-MM-DD hh:mm:ss, in my table. I want to also find something just for a particular day regardless of the time. (Pg)SQL way to do this ? TIA, Aarni -- -------------- This is a bugfree broadcast to you from **Kmail** on **Fedora Core** linux system --------------