Below is my Query :
Quote:
Select a.Sent, b.Recd, ((b.Recd-a.Sent)*1440) DIFF
from TableA b, TableB a
where b.type = 'AAA'
and b.ID = a.ID1
Where ID and ID1 are foreign Key
Both sent, Recd dates are in format like '
Quote:
5/9/2011 5:22:00 PM
'
But i am not getting :
Quote:
((b.Recd-a.Sent)*1440)
in minutes
Instead i am getting like
Quote:
-000000000 06:48:00
I need the difference of DATE in Minutes only.
Please suggest.