mysql linux时间转,将Uinx、MySQL时间戳转换为DateTime

将Uinx、MySQL时间戳转换为DateTime

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

namespace ShopEX_Console.CodesClass

{

///

/// 将Uninx时间戳转换为DateTime格式

///

class UinxTime

{

///

/// 将Unix时间戳转换为DateTime类型时间

///

/// double 型数字

/// DateTime

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;

}

///

/// 将c# DateTime时间格式转换为Unix时间戳格式

///

/// 时间

/// double

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;

}

}

}