Re: Really strange bug? (View, Partitioning)

On Tue, 09 Apr 2002, marc_at_marcblum.de wrote:
> SELECT *
> FROM my_view
> WHERE adress = 'home sweet home'
> AND my_timestamp
> BETWEEN to_date('01.03.2002','dd.mm.yyyy')
> AND to_date('30.04.2002','dd.mm.yyyy')
>
> returns NO ROWS!!!!!!!!

I'm not even sure if it would help or shed light, but I'd be curious. What does count(*) bring back?

How bout
SELECT *
       [...]
AND to_date('30.03.2002','dd.mm.yyyy')?

How bout
SELECT *
       [...]
BETWEEN to_date('01/03/2002','dd/mm/yyyy') AND to_date('30/03/2002','dd/mm/yyyy')?

other iterations as well?

-- 
Galen deForest Boyer
Sweet dreams and flying machines in pieces on the ground.