/// <summary> /// 将Unix时间戳转换为DateTime类型时间 /// </summary> /// <param name="d">double 型数字</param> /// <returns>DateTime</returns> public static System.DateTime ConvertIntDateTime(double d) { //SQL Server 转换:select DATEADD(s, 1516866377, '1970-01-01 00:00:00') //MySql 转换: FROM_UNIXTIME(1516866377)as servertime
//MySql 毫秒格式时间戳转换 要除以1000就变成秒格式 FROM_UNIXTIME(floor((1528681728997/1000)))as curtime
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> /// 将c# DateTime时间格式转换为Unix时间戳格式 /// 直接用(DateTime.Now.ToUniversalTime().Ticks - 621355968000000000) / 10000000 可获得当前时间的Unix时间戳 /// </summary> /// <param name="time">时间</param> /// <returns>double</returns> public static double ConvertDateTimeInt(System.DateTime time) { //SQL Server 转换:SELECT DATEDIFF(s, '1970-01-01 00:00:00', GETUTCDATE()) double intResult = 0; System.DateTime startTime = TimeZone.CurrentTimeZone.ToLocalTime(new System.DateTime(1970, 1, 1)); intResult = (time - startTime).TotalSeconds; return intResult; }
Unix时间戳在线转换工具
http://tools.sharejs.com/unixtime.html
tool.chinaz.com/Tools/unixtime.aspx