Re: Difference between two dates

Hello likw,
Simple Question, Simple Answer.
Try:
Finish_date - Start_Date
Günter

likw schrieb:

> Customer_name; Start_Date; Finish_Date
> --------------------------------------
> ABC; 02-Nov-99; 10-Nov-99
> CDE; 12-Nov-99; 15-Nov-99
> GHI; 18-Dec-99; 25-Jan-00
>
> Could you help to get the difference between two Dates??
>
> I wish to have the result like below
> Customer_name; Days difference (Finish date - Start date) for each
> customer.
>
> Can you help?? I don't know how to do subtraction in SQL (Oracle).
>
> * Sent from RemarQ http://www.remarq.com The Internet's Discussion Network *
> The fastest and easiest way to search and participate in Usenet - Free!
Received on Sun Nov 07 1999 - 02:51:22 CST