锘?!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
銆銆TimeSpan鐨勭敤娉?/span>
銆銆TimeSpan鏄敤鏉ヨ〃紺轟竴涓椂闂存鐨勫疄渚嬶紝涓や釜鏃墮棿鐨勫樊鍙互鏋勬垚涓涓猅imeSpan瀹炰緥錛岀幇鍦ㄥ氨鏉ョ畝鍗曚粙緇嶄竴涓嬪嚑鐐歸噸瑕佺殑鐢ㄦ硶錛?/span>
銆銆a 鍏堟潵浠嬬粛鍑犱釜鏂規硶
銆銆TimeSpan.Minutes(鍏朵粬鏃墮棿姣斿澶╂暟錛屽皬鏃舵暟錛岀鏁伴兘涓鏍風殑鎯呭喌涓嬪緱鍒扮殑鍒嗛挓鏁扮殑宸?,鍏朵粬鐨凥ours錛孲econd涓鏍?/span>
銆銆DateTime.Tick :鏄竴涓鏃跺懆鏈燂紝琛ㄧず涓鐧劇撼縐掞紝鍗充竴鍗冧竾鍒嗕箣涓縐掞紝閭d箞 Ticks 鍦ㄨ繖閲岃〃紺烘誨叡鐩稿樊澶氬皯涓椂闂村懆鏈燂紝鍗籌細9 * 24 * 3600 * 10000000 + 23 * 3600 * 10000000 + 59 * 60 * 10000000 + 59 * 10000000 = 8639990000000銆?600 鏄竴灝忔椂 鐨勭鏁?/span>
銆銆TimeSpan.TotalDays:涓や釜鏃墮棿孌電浉宸殑鏃ユ暟錛屽叾浠栫殑TotalHours,TotalMinutes,TotalSeconds 涓鏍?/span>
銆銆b 涓や釜鏃墮棿鐨勫樊
銆銆string time1 = "2010-5-26 8:10:00";
銆銆string time2 = "2010-5-26 18:20:00";
銆銆DateTime t1 = Convert.ToDateTime(time1);
銆銆DateTime t2 = Convert.ToDateTime(time2);
銆銆TimeSpan ts1=t2-t1;
銆銆string tsMin=ts1.Minutes.ToString();
銆銆TimeSpan ts11=new TimeSpan(t1.Tick);
銆銆TimeSpan ts22=new TimeSpan(t2.Tick);
銆銆string diff=ts22.Subtract(ts11).TotalMinutes.ToString();
銆銆Subtract:琛ㄧず涓や釜鏃墮棿孌電殑宸?/span>
銆銆diff:灝辮〃紺轟袱涓椂闂寸浉宸殑鍒嗛挓鏁幫紝涓婇潰鐨勪緥瀛愬氨鏄?10鍒嗛挓銆?/span>
銆銆--cs浠g爜--
銆銆DateTime t1 = DateTime.Parse("1998-2-25 ");
銆銆DateTime t2 = DateTime.Parse("2009-7-28");
銆銆System.TimeSpan ts=t2-t1;
銆銆int day = ts.Days;
銆銆--sql浠g爜--
銆銆select year=datediff(year,'2009-2-25','2009-7-28' ) , month=datediff(month,'2009-2-25','2009-7-28')
銆銆select month=datediff(month,'2009-2-25','2009-7-28')
銆銆select day=datediff(day,'2009-2-25','2009-7-28')