TimeSpan.TotalD ays versus DateTime.ToOADa te difference

[=?Utf-8?B?RGFwcGVyRGFuSEBub3NwYW0ubm9zcGFt?=]

Given the example below, can someone explain why TimeSpan.TotalD ays gives a
different result than subtracting 2 DateTime.ToOADa tes?

I am completely stumped. Thanks in advance,
Dan

Example Output:

start: 1/1/2007 12:00:00 AM
end : 1/1/2007 1:00:00 AM

(end - start).TotalDay s : 0.0416666666666 667
(end.ToOADate() - start.ToOADate( )) : 0.0416666666642 413
((decimal)end.T oOADate() - (decimal)start. ToOADate()) : 0.0416666667

Code:

using System;
using System.Collecti ons.Generic;
using System.Text;

namespace DurationTest
{
class Program
{
static void Main(string[] args)
{
DateTime start = new DateTime(2007, 1, 1, 0, 0, 0);
DateTime end = new DateTime(2007, 1, 1, 1, 0, 0);

Console.WriteLi ne("start: " + start);
Console.WriteLi ne("end : " + end);
Console.WriteLi ne();

TimeSpan duration = end - start;
Console.WriteLi ne("(end - start).TotalDay s
: " + duration.TotalD ays);

double totalDays = end.ToOADate() - start.ToOADate( );
Console.WriteLi ne("(end.ToOADa te() - start.ToOADate( ))
: " + totalDays);

decimal totalDays2 = ((decimal)end.T oOADate()) -
((decimal)start .ToOADate());
Console.WriteLi ne("((decimal)e nd.ToOADate() -
(decimal)start. ToOADate()) : " + totalDays2);

Console.ReadLin e();
}
}
}

[=?UTF-8?B?R8O2cmFuIEFuZGVyc3Nvbg==?=]

Da********@nosp am.nospam wrote:

Given the example below, can someone explain why TimeSpan.TotalD ays gives a
different result than subtracting 2 DateTime.ToOADa tes?

I am completely stumped. Thanks in advance,
Dan

Example Output:

start: 1/1/2007 12:00:00 AM
end : 1/1/2007 1:00:00 AM

(end - start).TotalDay s : 0.0416666666666 667
(end.ToOADate() - start.ToOADate( )) : 0.0416666666642 413
((decimal)end.T oOADate() - (decimal)start. ToOADate()) : 0.0416666667

DateTime and TimeSpan are 64 bit values which represent time in 1/10000
seconds.

When you convert this to a double value, you lose precision. A double is
also a 64 bit value, but only 52 bits are used for the actual data. You
only get nine to ten significant digits after the decimal point in an
OADate, so the last six digits that you see is just noise.

The conversion from double to decimal doesn't cause any further loss of
precision, but you can't get anything back that was lost in the first
conversion. The second and third results are equivalent, they are only
displayed differently because the decimal values keep track of how much
significant data there actually is.

--
Göran Andersson
_____
http://www.guffa.com