Convert the timestamp of ubench and MySQL to DateTime
Using System;
Using System. Collections. Generic;
Using System. Linq;
Using System. Text;
Namespace shopex_lele.codesclass
{
/// <Summary>
/// Convert the unformatted timestamp to the DateTime format
/// </Summary>
Class UinxTime
{
/// <Summary>
/// Convert Unix timestamp to DateTime type time
/// </Summary>
/// <Param name = "d"> double digit </param>
/// <Returns> DateTime </returns>
Public System. DateTime ConvertIntDateTime (double d)
{
System. DateTime time = System. DateTime. MinValue;
System. DateTime startTime = TimeZone. CurrentTimeZone. ToLocalTime (new System. DateTime (1970, 1, 1 ));
Time = startTime. AddSeconds (d );
Return time;
}
/// <Summary>
/// Convert the c # DateTime time format to the Unix timestamp format
/// </Summary>
/// <Param name = "time"> time </param>
/// <Returns> double </returns>
Public double ConvertDateTimeInt (System. DateTime time)
{
Double intResult = 0;
System. DateTime startTime = TimeZone. CurrentTimeZone. ToLocalTime (new System. DateTime (1970, 1, 1 ));
IntResult = (time-startTime). TotalSeconds;
Return intResult;
}
}
}