How to Convert DateTime 30-Jun-2002 12:00:00 AM to Double?

Question

Hi all, I am trying to retrieve data from MySql db. The one column is DateTime type 12-Jun-90 12:00:00 AM and the other column is type double Price(15.00). Could you please tell me how to Convert the DateTime to double in order to perform some stastistical calculations and visualisation with R.NET? R.NET requires only Numerical vectors

Rajeesh Menoth · Answer

Hi, Ref the following.. 1) http://stackoverflow.com/questions/17804933/convert-datetime-to-double 2) http://bytes.com/topic/c-sharp/answers/653685-why-cant-datetime-converted-double 3) http://sajalhalder.blogspot.in/2008/05/convert-double-to-datetime-datetime-to.html

Raja T · Answer

Hi, Try this var converted = DateTime.Now.ToOADate(); Decimal dateIndDec = Convert.ToDecimal(DateTime.Today.ToOADate()); Checkout bellow url for details https://msdn.microsoft.com/en-us/library/system.datetime.tooadate.aspx

Algorithmlearner · Answer

Hi guys and thanks for your mails. But this doesnt work since i want to store DateTime values from MySql Database into a variable in my front end (C#) and then use this variable as numeric. At the moment i retrieve my db data and store them in a List I need to Convert this list to double.

Algorithmlearner · Answer

it says i am missing a using directing or assembly reference

Algorithmlearner · Answer

It returns me invalid cast from DateTime to Decimal

Sunil Gaded · Answer

Decimal datetime=Convert.ToDecimal(Date_variable);

Manas Mohapatra · Answer

Hi, As per your requirement you need to use OADate(). It returns OLE automation date in double format which you need for calculation. var dataVal = DateTime.Now.ToOADate(); http://www.c-sharpcorner.com/Blogs/4312/