Message-ID: <39F4CD69.5B5724A1@selectacast.net>
Date: Mon, 23 Oct 2000 19:44:41 -0400
From: Joseph Shraibman <jks@selectacast.net>
Organization: Xtenit
MIME-Version: 1.0
To: khkachn@toad.net
CC: pgsql-interfaces@postgresql.org
Subject: Re: RE: datetime fix
References: <39F04B7E.D27393FF@toad.net>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Put 
query=1

into pg_options to see exactly why query is being executed.

Ken Kachnowich wrote:
> 
> 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

-- 
Joseph Shraibman
jks@selectacast.net
Increase signal to noise ratio.  http://www.targabot.com