|
JaniceD
Starting Member
1 Posts |
 Posted - 10/19/2012 : 06:51:15
|
I wan to calculate difference between two datetime fields in minutes; I am using below expression in SSIS;
DATEDIFF("Mi",[Email_Time],End_Time)
but this is returning integer values but i want diffence to be considered in decimal as well.
e.g if Email Time= 4/2/2012 2:54:00 PM
and End Time=4/2/2012 3:17:22 PM
then i want return values to be 23.22
Is there any way through which we can achieve this if datediff is not the solution |
|
Get difference between two datetime fields in SSIS
