MSSQL常用日期格式
Select DateAdd ( dd, -Day ( GetDate ()) + 1, GetDate ()) '当月起始时间'; --查询当月起始时间 Select DateAdd ( ms, -3, DateAdd ( mm, DateDiff ( m, 0, GetDate ()) + 1, 0 )) '当月结束时间'; --查询当月结束时间 Select DateAdd ( dd, -Day ( DateAdd ( Month, -1, GetDate ())) + 1, DateAdd ( Month, -1, GetDate ())) '上月起始时间'; --查询上月起始时间 Select DateAdd ( dd, -Day ( GetDate ()), GetDate ()) '上月结束时间'; --查询上月结束时间 Select DateAdd ( Quarter, DateDiff ( Quarter, 0, GetDate ()) - 1, 0 ) As '当前季度的上个季度初'; --查询当前季度的上个季度开始时间 Select DateAdd ( Quarter, DateDiff ( Quarter, 0, GetDate ()), -1 ) As '当前季度的上个季度末'; --查询当前季度的上个季度结束时间 Select DateAdd ( Quarter, DateDiff ( Quarter, 0, GetDate ()), 0 ) As '当前季度的第一天'; --查询当前季度起始时间 Select DateAdd ( Quarter, 1 + DateDiff ( Quarter, 0, GetDate ()), -1 ) As '当前季度的最后一天'; --查询当前季度结束时间 Select DateAdd ( Quarter, 1 + DateDiff ( Quarter, 0, GetDate ()), 0 ) As '当前季度的下个季度初'; --查询当前季度下个季度开始时间 Select DateAdd ( Quarter, 2 + DateDiff ( Quarter, 0, GetDate ()), -1 ) As '当前季度的下个季度末'; --查询当前季度下个季度结束时间 Select DateAdd ( Year, DateDiff ( Year, 0, DateAdd ( Year, -1, GetDate ())), 0 ) '去年的第一天'; --去年的第一天 Select DateAdd ( Year, DateDiff ( Year, 0, GetDate ()), -1 ) '去年最后一天'; --去年的最后一天 Select DateAdd ( Year, DateDiff ( Year, 0, GetDate ()), 0 ) '当年的第一天'; --当年的第一天 Select DateAdd ( Year, DateDiff ( Year, 0, DateAdd ( Year, 1, GetDate ())), -1 ) '当年的最后一天'; --当年的最后一天
共有条评论 网友评论