DATE column difference in minutes.

From: Guna Govind <guna_at_gwcom.com>
Date: 1997/05/22
Message-ID: <3384BC5C.671B@gwcom.com>#1/1

Hi,

posting this on behalf of my colleque..

I'm using Oracle7.3 on Solaris 2.5.1.
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 CDT