Re: date

From: johnj <u21624_at_uwe>
Date: Mon, 08 May 2006 00:35:48 GMT
Message-ID: <5feb18ebb0f95@uwe>

Is the select statement ok

SELECT customerID, lname, fname, orderdate, SUM(c.cost, c.extracharges) * 100 AS percent

FROM customer c, customerCharges ch
WHERE c.customerID = ch.customerCharges AND orderdate>=TO_DATE('1/1/2001','DD/MM/YYYY') AND orderdate<TO_DATE('1/1/2002','DD/MM/YYYY')

And also is it possible to specify two dates example

AND (orderdate, shipdate)>=TO_DATE('1/1/2001','DD/MM/YYYY') AND (orderdate,shipdate)<TO_DATE('1/1/2002','DD/MM/YYYY')

thanks Received on Sun May 07 2006 - 19:35:48 CDT