Re: Subtracting Dates

From: Hans Forbrich <forbrich_at_telusplanet.net>
Date: Tue, 29 Jul 2003 13:04:12 GMT
Message-ID: <3F266F11.DADF7CBA@telusplanet.net>

carlos_lotero wrote:

> Hello,
>
> I need to show the difference between dates in format: hh24:mi:ss.
>

Others have already told you how to get the difference between the dates.

Now go to the SQL Reference manual to look up the 'to_char' format spec to display the days in the format you want. (Gentle reminder - my fav mistake is forgetting the difference is a number, not a date.)

That manual is at http://otn.oracle.com >> documentation >> your database version >> list of books

HTH
/Hans Received on Tue Jul 29 2003 - 08:04:12 CDT