Re: date

"johnj" <u21624_at_uwe> wrote in message news:5fea8b6e9c65e_at_uwe...
> I have a query that I wanted it to return percentage charges within the
year
> 2001
>
> SELECT customerID, lname, fname, SUM(cost,extrCharges) * 100 AS percent
> FROM customer c, customerCharges ch
> WHERE c.customerID = ch.customerCharges
>
> how can I specify the year of 2001 in my select command?
>
>
> thanks
>
> johnj

and
the_date>=to_date('1/1/2001','dd/mm/yyyy') and the_date<to_date('1/1/2002','dd/mm/yyyy') Received on Sun May 07 2006 - 18:49:36 CDT