From: Joseph Shraibman <jks@selectacast.net>
To: khkachn@toad.net
Cc: pgsql-interfaces@postgresql.org
Subject: Re: RE: datetime fix
Date: Mon, 23 Oct 2000 19:44:41 -0400
Message-ID: <39F4CD69.5B5724A1@selectacast.net> (raw)
References: <39F04B7E.D27393FF@toad.net>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: jks@selectacast.net, khkachn@toad.net
Subject: Re: RE: datetime fix
In-Reply-To: <39F4CD69.5B5724A1@selectacast.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox