Date Comparison in C# with millisecond

            DateTime dt1 = Convert.ToDateTime("04/17/2014 04:05:25.8652258 AM");
            DateTime dt2 = Convert.ToDateTime("04/17/2014 04:05:25.8652258 PM");
            int Res = DateTime.Compare(dt1, dt2);//args[0] is latest time, args[1] is old time
            
If Res returns 0(zero) then both values are equal.
If Res returns -1 then dt2 is the latest time
If Res returns 1 then the condition is true. dt1 is latest. 

SQL Result as vertical

create table test (CustomerID int,CustomerName varchar(50),Location varchar(50))
Insert into test values (101,'IBM','NY'),(102,'MSFT','WA')
select * from test
--Method-1
Select Col,Val from test
cross apply (values('customerID',Cast(customerID as varchar(50))),('CustomerName',CustomerName),('Location',Location) ) d(Col,Val)


--Method-2
Select Col,Val from (select Cast(customerID as varchar(50)) as customerID,CustomerName,Location from test) src
unpivot (val For col in ([customerID],[CustomerName],[Location])) unpvt

drop table test