Re: Difference between Times

Try setting the NLS_DATE_FORMAT in your session to include hours,minutes and even secs.
Command is ALTER SESSION SET NLS_DATE_FORMAT=<FORMAT>(eg:DD-MM-YY:HH-MI:SS)

Ed Jennings <jennings_at_dca.net> wrote in article <325451C8.2210_at_dca.net>...
> I know that by subtracting two dates I can get an integer that
> represents the number of days bewteen the tow dates.
> However, I need a solution that is more granular.
> Does anyone know how to get the difference between two date
> types in hours & minutes? The times of two events are
> being stored in date format columns. I need to compute the time
> between the two events.
> --
> ~~~~~~~~~~~~~~~~~~~~~~~~~
> jennings_at_dca.net
>
  Received on Thu Oct 10 1996 - 00:00:00 CEST