摘要: 应用:取得某一日所在周的开始和结束 week_start = dateadd(day, 1-datepart(weekday, @p_today), @p_today) week_end = dateadd(day, 7-datepart(weekday, @p_today), @p_today) DateAdd函数 返回包含一个日期的 Variant (Date),这一日期还加上了一段... 阅读全文
posted @ 2007-09-03 15:32 Microbar 阅读(878) 评论(0) 推荐(0) 编辑