Re: ORACLE DATE IN WHERE CLAUSE PROBLEMS

From: Aniruddha Ghosh <andyg_at_pluto.njcc.com>
Date: 1995/06/28
Message-ID: <3ssjhp$rci_at_earth.njcc.com>#1/1

Davor Saric (davor_at_crocker.com) wrote: : Can anyone explain this strange phenomenon to me ?

I am not positive but looks like an embedded time value is creating the problem.
Try
select count(*)
from orders
where trunc(order_date) between to_date etc...

andyg_at_pluto.njcc.com Received on Wed Jun 28 1995 - 00:00:00 CEST

This message: [ Message body ]
Next message: Vince Cross: "Re: Oracle Forms & NT, will it work ?"
Previous message: Herman de Boer: "Re: ORACLE DATE IN WHERE CLAUSE PROBLEMS"
In reply to: Davor Saric: "ORACLE DATE IN WHERE CLAUSE PROBLEMS"
Next in thread: Vince Cross: "Re: Oracle Forms & NT, will it work ?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message