DATE column difference in minutes.
From: Guna Govind <guna_at_gwcom.com>
Date: 1997/05/22
Message-ID: <3384BC5C.671B_at_gwcom.com>#1/1
| General Wireless Comm. Inc. | email: meena_at_gwcom.com |
| 3350 Scott Blvd. Bldg# 36 | phone: (408) 986 8988 Ext.148 |
| Santa Clara, CA 95054 | |
Received on Thu May 22 1997 - 00:00:00 CEST
Date: 1997/05/22
Message-ID: <3384BC5C.671B_at_gwcom.com>#1/1
Hi,
[Quoted] posting this on behalf of my colleque..
I'm using Oracle7.3 on Solaris 2.5.1.
[Quoted] I need to calculate the time difference in minutes from 2 character
strings (basically the timestamp is stored in a 'C' program
as a charcter string). I tried to convert the character string
to "date" format using "to_date", and subtracted them. But it always
subtracts the date portion of the timestamp, but not the time.That is,
if I subtract two different times on the same date, I always
get '0'.
Any help on this, is greatly appreciated.
Regards,
Meena
| General Wireless Comm. Inc. | email: meena_at_gwcom.com |
| 3350 Scott Blvd. Bldg# 36 | phone: (408) 986 8988 Ext.148 |
| Santa Clara, CA 95054 | |
Received on Thu May 22 1997 - 00:00:00 CEST