Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
Lists: pgsql-interfaces

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
Increase signal to noise ratio.

In response to


pgsql-interfaces by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group