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