Received: from hub.org.org (localhost [127.0.0.1]) by hub.org (8.10.1/8.11.0) with SMTP id e9NKTpN36584 for ; Mon, 23 Oct 2000 16:29:51 -0400 (EDT) (envelope-from pgsql-interfaces-owner@hub.org) Received: from sushi.toad.net (IDENT:root@sushi-old.toad.net [209.150.117.251]) by hub.org (8.10.1/8.11.0) with ESMTP id e9KDefJ88280 for ; Fri, 20 Oct 2000 09:40:41 -0400 (EDT) (envelope-from khkachn@toad.net) Received: from toad.net (core19d185.dynamic-dialup.toad.net [162.33.189.185]) by sushi.toad.net (8.9.3/8.9.3) with ESMTP id JAA29965 for ; Fri, 20 Oct 2000 09:40:38 -0400 Message-ID: <39F04B7E.D27393FF@toad.net> Date: Fri, 20 Oct 2000 09:41:18 -0400 From: Ken Kachnowich Reply-To: khkachn@NOSPAMtoad.net X-Mailer: Mozilla 4.61 [en] (Win98; I) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-interfaces@postgresql.org Subject: RE: datetime fix Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200010/189 X-Sequence-Number: 1546 Whoops, sorry. I did not know the -04 was the time zone and thought it was causing my problem. My problem still exists, so I may be doing something else wrong. Has anyone done something like this and does it work? - Create a Timestamp with the curret date/time in it - Insert it into a datetime field in table A - Insert it into a datetime field in table B - select the datetime field from table A into a Timestamp variable - Use this Timestamp variable to select the record from table B I get no records found when I do this. Ken