SQL报表语句代码,MSSQL代码库,德仔网

代码语言

代码分类

【MSSQL】 SQL报表语句

作者:子琦 / 发布于2015/1/7/ 899


	昨天　

	select convert(varchar(10),getdate() - 1,120)

	明天

	select convert(varchar(10),getdate() + 1,120)

	最近七天

	select * from tb where 时间字段 >= convert(varchar(10),getdate() - 7,120)

	随后七天

	select * from tb where 时间字段 <= convert(varchar(10),getdate() + 7,120) and 时间字段 >= 时间字段

	上月

	select * from tb where month(时间字段) = month(getdate()) - 1

	本月

	select * from tb where month(时间字段) = month(getdate())

	下月

	select * from tb where month(时间字段) = month(getdate()) + 1

	--昨天　

	Select * From TableName Where DateDiff(dd, DateTimCol, GetDate()) = 1

	--明天

	Select * From TableName Where DateDiff(dd, GetDate(), DateTimCol) = 1

	--最近七天

	Select * From TableName Where DateDiff(dd, DateTimCol, GetDate()) <= 7

	--随后七天

	Select * From TableName Where DateDiff(dd, GetDate(), DateTimCol) <= 7

	--上周

	Select * From TableName Where DateDiff(wk, DateTimCol, GetDate()) = 1

	--本周

	Select * From TableName Where DateDiff(wk, DateTimCol, GetDate()) = 0

	--下周

	Select * From TableName Where DateDiff(wk, GetDate(), DateTimCol ) = 1

	--上月

	Select * From TableName Where DateDiff(mm, DateTimCol, GetDate()) = 1

	--本月

	Select * From TableName Where DateDiff(mm, DateTimCol, GetDate()) = 0

	--下月

	Select * From TableName Where DateDiff(mm, GetDate(), DateTimCol ) = 1

	--------------------------------------------------------

	本周

	select * from tb where datediff(week , 时间字段 ,getdate()) = 0

	上周

	select * from tb where datediff(week , 时间字段 ,getdate()) = 1

	下周

	select * from tb where datediff(week , 时间字段 ,getdate()) = -1

试试其它关键字

　SQL报表语句　　报表语句　

同语言下

可能有用的

子琦贡献的其它代码(1)

.SQL报表语句