Re: How to formate date in where clause?

try:

select a,b c
from d_table
where trunc( drop_date ) = trunc( sysdate - 1 );

This is a time component in the date field, therefore your query would have to match down to the second.

Michael

Maggie wrote:

> I tried to run a query:
>
> select a,b c
> from d_table
> where drop_date = sysdate - 1;
>
> However, I coundn't get value return even I know there are rows matched to
> the query. I understand there must some way to format date. Can anyone
> help?
>
> Thansk.
> Maggie
Received on Thu Jun 08 2000 - 00:00:00 CDT