编程相关杂集
殇槊
风物长宜放眼量
展开
-
关于日期的查询
生日查询:(例如:8.1~8.15之间过生日的)select * from presoninfo where dateadd(year,datediff(year,flocktime,2009-8-1),flocktime)between 2009-8-1 and 2009-8-15 or dateadd(year,datediff(year,flocktime,20转载 2009-09-11 10:24:00 · 273 阅读 · 0 评论 -
计算日期差值
public static TimeSpan DateTimeDiff(DateTime dt1, DateTime dt2) { TimeSpan span = dt2.Subtract(dt1); return span; } ASP.NET转载 2009-09-11 11:12:00 · 227 阅读 · 0 评论