Re: date

thanks Jim. pls look at the code below, the last line. I'm I right?

SELECT customerID, lname, fname, SUM(cost,extrCharges) * 100 AS percent

    FROM customer c, customerCharges ch
    WHERE c.customerID = ch.customerCharges     AND YEAR(c.orderdate) = YEAR(2001());

Jim Kennedy wrote:
>> I have a query that I wanted it to return percentage charges within the year
>> 2001
>[quoted text clipped - 8 lines]
>>
>> 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 - 19:03:37 CDT