Re: datetime queries in postgres

[vp@example.com (Viktor Pavlenko)]

Well this is what happen when you don't have to retype your
query in psql, just hit 'up' key... and when your jsp page is
smart enough to remember your last query...

The results below are correct. If 2000 is replaced with 2001
in select it does exactly what I was expecting.

Thanks for the reply, Jake. You can never discard "blidness"
errors.

Viktor


> I'm having some very strange problems in Postgres (7.0.2)
> 
> There's a DATETIME field in the table. Most of queries with
> this field give wrong results:
> 
> >SELECT time FROM tb;
> 
> 2001-05-18 07:45:26+09
> 2001-05-18 07:45:28+09
> 2001-05-18 08:58:06+09
> 2001-05-18 08:58:06+09
> 
> >SELECT * FROM tb WHERE time > '2000-05-18 8:00:00';
> 
> 2001-05-18 07:45:26+09
> 2001-05-18 07:45:28+09
> 2001-05-18 08:58:06+09
> 2001-05-18 08:58:06+09
> 
> >SELECT * FROM tb WHERE time < '2000-05-18 8:00:00';
> 
> (0 rows)
>