获取当前月的第一天和最后一天...

set @F_d = convert(varchar(10),dateadd(dd,-day(getdate())+1,getdate()),120)
set @E_d = convert(varchar(10),dateadd(dd,-day(getdate()),dateadd(m,1,getdate())),120)

posted on 2009-07-09 15:11  封起De日子  阅读(105)  评论(0编辑  收藏  举报

导航