From: Ken Kachnowich <khkachn@toad.net>
To: pgsql-interfaces@postgresql.org
Subject: RE: datetime fix
Date: Fri, 20 Oct 2000 09:41:18 -0400
Message-ID: <39F04B7E.D27393FF@toad.net> (raw)
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
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: khkachn@toad.net
Subject: RE: datetime fix
In-Reply-To: <39F04B7E.D27393FF@toad.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