Re: Date Difference
From: 170 Systems <170sys_at_netcom.com>
Date: Wed, 25 Jan 1995 18:47:45 GMT
Message-ID: <170sysD2z5JL.Ht3_at_netcom.com>
Date: Wed, 25 Jan 1995 18:47:45 GMT
Message-ID: <170sysD2z5JL.Ht3_at_netcom.com>
You guys are all eating too much Thai food! (not that there's anything wrong with that...)
select to_char(abs(trunc(24*(first_date - second_date)))) || ':' ||
ltrim(to_char(abs(trunc(24*60*(first_date - second_date)) -
(60*trunc(24*(first_date - second_date)))), '00')) || ':' ||
ltrim(to_char(abs(trunc(24*60*60*(first_date - second_date)) -
(60*trunc(24*60*(first_date - second_date)))), '00'))
from your_table;
- Dan