2012年6月15日
Useful WebSite
摘要： http://www.codeguru.com/csharp/.net/net_asp/controls/article.php/c12235/ASPNET-Booking-Calendar-User-Control.htmBooking Calendar 阅读全文
posted @ 2012-06-15 19:48 hishanghai 阅读(78) 评论(0) 推荐(0) 编辑
WeekDay TO DateTime
摘要： SELECTCONVERT(VARCHAR,(DATEADD(week,1,getdate())-(DATEPART(DW,DATEADD(week,1,getdate())))),23)as下周一SELECTCONVERT(VARCHAR,(DATEADD(week,1,getdate())-(DATEPART(DW,DATEADD(week,1,getdate())))+1),23)SELECTCONVERT(VARCHAR,(DATEADD(week,1,getdate())-(DATEPART(DW,DATEADD(week,1,getdate())))+2),23)SELECTCON 阅读全文
posted @ 2012-06-15 19:23 hishanghai 阅读(151) 评论(0) 推荐(0) 编辑
sql 得到一周的 開始時間 結束時間
摘要： DECLARE@REPORT_DATEDATETIME,@WEEK_BEGININGVARCHAR(10)SELECT@REPORT_DATE=getdate()SELECT@WEEK_BEGINING='MONDAY'IF@WEEK_BEGINING='MONDAY'SETDATEFIRST1ELSEIF@WEEK_BEGINING='TUESDAY'SETDATEFIRST2ELSEIF@WEEK_BEGINING='WEDNESDAY'SETDATEFIRST3ELSEIF@WEEK_BEGINING='THURSD 阅读全文
posted @ 2012-06-15 17:47 hishanghai 阅读(426) 评论(0) 推荐(0) 编辑