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: 39F4CD69.5B5724A1@selectacast.net (view raw or flat)
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

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-2014 The PostgreSQL Global Development Group