Re: date

"johnj" <u21624_at_uwe> wrote in news:5feb18ebb0f95_at_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
>

It appears that you either unwilling or incapable of RTFM found at http://tahiti.oracle.com
specifically
http://download-west.oracle.com/docs/cd/B19306_01/server.102/b14200/toc.htm Received on Sun May 07 2006 - 19:45:01 CDT