时间相加其实是指某个日期+天数 ,总不能让两个时间真的相加吧
时间相减指的是两个时间相间隔的天数或者小时等
先说js
时间相加:
<script type="text/javascript">
function date() {
//var dD = new Date(date[0], date[1], date[2]);
var date = new Date(Date.parse("2014-02-28"));
var newdate = new Date(date.setDate(date.getDate() + 1)); //Sun Feb 9 08:00:00 UTC+0800 2014
var s = Todate(newdate);
var txt = document.getElementById("TextBox1");
txt.value = s;
}
function Todate(num) {
num = num + "";
var date = "";
var month = new Array();
month["Jan"] = 1; month["Feb"] = 2; month["Mar"] = 3; month["Apr"] = 4; month["May"] = 5; month["Jan"] = 6;
month["Jul"] = 7; month["Aug"] = 8; month["Sep"] = 9; month["Oct"] = 10; month["Nov"] = 11; month["Dec"] = 12;
var week = new Array();
week["Mon"] = "一"; week["Tue"] = "二"; week["Wed"] = "三"; week["Thu"] = "四"; week["Fri"] = "五"; week["Sat"] = "六"; week["Sun"] = "日";
str = num.split(" ");
date = str[5] + "-";
date = date + month[str[1]] + "-" + str[2];
return date;
}
</script>
时间间隔:
<script type="text/javascript">
function syDate() {
var t1 = new Date(Date.parse("2014-02-28"));
var t2 = new Date(Date.parse("2014-03-01"));
var difference = t2.getTime() - t1.getTime(); //剩余时间
var thisdays = Math.floor(difference / (1000 * 60 * 60 * 24)); //剩余天
var thishours = Math.floor(difference / 3600000); //小时
var syDate = document.getElementById("TextBox1");
syDate.value ='时间相隔'+ thisdays + "天即" + thishours+"小时";
}
</script>
SQL语句的写法:
时间加上天数:2008-08-08+3天=2008-08-11
dateadd(d,3,'2008-08-08')
时间间隔:为当前时间-2014-02-01
select datediff(d,'2014-02-01',getdate())
知识点:年、月、日、时、分、秒
datediff(yy,date1,date2)
datediff(m,date1,date2)
datediff(d,date1,date2)
datediff(hh,date1,date2)
datediff(n,date1,date2)
datediff(s,date1,date2)
datediff(ms,date1,date2)
C#写法:
时间加上天数或小时或分钟等
DateTime t1 = DateTime.Parse("2014-02-28");
DateTime t=t1.AddDays(1);//日期+1天
DateTime tt = t1.AddYears(1);//日期+1年
DateTime twt = t1.AddHours(1);//日期+1小时
时间间隔
DateTime t1 = DateTime.Parse("2014-02-28");
DateTime t2 = DateTime.Parse("2014-02-01");
System.TimeSpan ts = t2 - t1;
int days = ts.Days;