特别说明下：以下统计本周数据时，星期天是作为下周的第一天，而不是本周最后一天，因此你把星期天作为本周最后一天时，你需要在getDate()的基础上减一天,如dateadd('day', -1, getDate()) 本周：select * from table where datediff(week,C_CALLTIME,getdat特别说明下：以下统计本周数据时，星期天是作为下周的第一天，而不是本周最后一天，因此你把星期天作为本周最后一天时，你需要在getDate()的基础上减一天,如dateadd('day', -1, getDate())本周：select * from table where datediff(week,C_CALLTIME,getdate())=0 --C_CALLTIME 为日期字段本月：select * from table where datediff(Month,C_CALLTIME,getdate())=0 --C_CALLTIME 为日期字段本季：select * from table where datediff(qq,C_CALLTIME,getdate())=0前半年1-6，后半年7-12：select * from table where datepart(mm,C_CALLTIME)/7 = datepart(mm,getdate())/7昨天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和dateadd函数结合使用就可以了。
用datediff(day,时间列,getdate())上月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())--随后七天Select * From TableName Where DateDiff(dd, GetDate(), DateTimCol)--上周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--------------------------------------------------------
1.现在我需要得到只是日期部分，
时间部分不要，SQL怎么写？
select convert(varchar(10),getdate(),120)
2.求以下日期
SQL:昨天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时间字段 时间字段 >=时间字段