Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id 085C8475FFF for ; Fri, 21 Jun 2002 05:42:44 -0400 (EDT) Received: from matrix.gatewaynet.com (unknown [217.19.69.50]) by postgresql.org (Postfix) with ESMTP id B6BD5475B48 for ; Fri, 21 Jun 2002 05:42:37 -0400 (EDT) Received: from localhost (achill@localhost) by matrix.gatewaynet.com (8.11.6/8.11.6) with ESMTP id g5L9jHW19071; Fri, 21 Jun 2002 12:45:17 +0300 Date: Fri, 21 Jun 2002 12:45:17 +0300 (EEST) From: Achilleus Mantzios To: juerg.rietmann@pup.ch Cc: pgsql-sql@postgresql.org Subject: Re: date_ge and time_ge In-Reply-To: Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Archive-Number: 200206/290 X-Sequence-Number: 8255 On Fri, 21 Jun 2002 juerg.rietmann@pup.ch wrote: > Hello > > I have a question regarding date_ge() and time_ge(). > > This statement works : > > select * from userlog where date_ge(ul_timestamp, '20.06.2002') > > > This statement doesn't work : > > select * from userlog where time_ge(ul_timestamp, '08:00:00') > See the large list of functions of pgsql. Use date_part, castings, etc... > > Here are some records from userlog : > > (See attached file: userlog.htm) > > __________________________________________________ > > PFISTER + PARTNER, SYSTEM - ENGINEERING AG > Juerg Rietmann > Grundstrasse 22a > 6343 Rotkreuz > Switzerland > > internet : www.pup.ch > phone : +4141 790 4040 > fax : +4141 790 2545 > mobile : +4179 211 0315 > __________________________________________________ > -- Achilleus Mantzios S/W Engineer IT dept Dynacom Tankers Mngmt tel: +30-10-8981112 fax: +30-10-8981877 email: achill@matrix.gatewaynet.com mantzios@softlab.ece.ntua.gr