Date arithmetic with oracle
From: Erik Johnson <ErikX_Johnson_at_ccm2.hf.intel.com>
Date: 1996/07/31
Message-ID: <31FFEBAD.7DD0_at_ccm2.hf.intel.com>#1/1
Date: 1996/07/31
Message-ID: <31FFEBAD.7DD0_at_ccm2.hf.intel.com>#1/1
I need to calculate the number of hour between 2 dates. So if I had:
date_a 7/31/96 10:10:10
date_b 7/31/96 12:12:12
date_b - date_a = 2 hrs.
How can I do this in a SQL statement with Oracle?? Just subtracting the dates gives me nothing. And I've tried messing with the different date functions and formats with no luck.
Thanks in advance for any help.
--Received on Wed Jul 31 1996 - 00:00:00 CEST