2004年4月7日
T-SQL 生成 两个新的真正的公历年历
摘要： datefirst 无关版 2004-09-29:-- playyuer@Microshaoft.com invent-- http://www.Microshaoft.comdeclare @ datetimeset @ = '1995-02-25 11:00:50'set @ = getdate()--set datefirst 3select @ as Date ,dateadd(year,datediff(year,0,@),0) as FirstDayOfYear ,dateadd(year,1+datediff(year,0,@),0)-1 as LastDayOf 阅读全文
posted @ 2004-04-07 14:34 于斯人也 阅读(148) 评论(0) 推荐(0) 编辑