Re: RE: datetime fix

From: Joseph Shraibman <jks(at)selectacast(dot)net>
To: khkachn(at)toad(dot)net
Cc: pgsql-interfaces(at)postgresql(dot)org
Subject: Re: RE: datetime fix
Date: 2000-10-23 23:44:41
Message-ID: 39F4CD69.5B5724A1@selectacast.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

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(at)selectacast(dot)net
Increase signal to noise ratio. http://www.targabot.com

In response to

Responses

Browse pgsql-interfaces by date

  From Date Subject
Next Message Tom Lane 2000-10-24 01:57:47 JDBC now needs updates for large objects
Previous Message Sandro Dentella 2000-10-23 22:16:04 Again libpgtcl for Win9* & tcl 8.3