Conversion of double and datetime types

. Net uses the new date method, that is, int64 is used to replace the double storage time. However, the tooadate and formoadate methods of datatime are provided. If you enter these keywords in msdn, you can quickly find a way to use them.

 

 

Datetime basedate = new datetime (1899, 12, 30 );
Double basenumber = basedate. tooadate (); // convert the datetime to double

Double doublevalue = 0;
Datetime doubledate = datetime. fromoadate (doublevalue); // convert the double to datetime

Console. writeline (basenumber); // 0

Console. writeline (doubledate. tostring (); // 12/30/1899 12:00:00 AM
Console. writeline (doubledate. tostring ("yyyy-mm-dd hh: mm: SS"); // 1899-12-30 00:00:00