摘要:
/// <summary> /// 根据出生日期计算年龄 /// </summary> /// <param name="dtNow">当前时间</param> /// <param name="dtDOB">出生日期</param> /// <returns></returns> public static string GetAge(DateTime dtNow,DateTime dtBirthday) { string strAge = string.E 阅读全文
摘要:
SQLServer查询最近一天,三天,一周,一月,一季度方法一天"select * from T_news where datediff(day,addtime,getdate())=0";三天"select * from T_news where datediff(day,addtime,getdate())<= 2 and datediff(day,addtime,getdate())>= 0";一周"SELECT * FROM T_news WHERE (DATEPART(wk, addtime) = DATEPART(wk, 阅读全文
摘要:
一,截取的到的年月select convert(char(7),'2013-04-12 09:32:28.000',120);结果 2013-04select SUBSTRING(getdate(),0,8) ;二,截取到年月日select convert(varchar(10),getdate(),120);三,截取时间(HH:MM:SS)select convert(varchar(8),getdate(),108); 阅读全文
摘要:
页面显示 <asp:UpdatePanel ID="UpdatePanel10" runat="server"> <ContentTemplate> <asp:GridView ID="gdDate" runat="server" BorderColor="#9CBAEF" BorderWidth="1px" CellPadding="0" PageSize="20" Width="98%&quo 阅读全文