select * from tb where DateDiff(ww ,sDay ,GetDate()) = 0
似乎不行吧,我要的是MYSQL语句啊!
似乎不行吧,我要的是MYSQL语句啊!
SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GOALTER Function getWeekDay(@Date as DateTime ,@Type as int) Returns varchar(10) As Begin Declare @wd as int ,@strReturn as varchar(10) set @wd = DatePart(dw ,@Date) if @Type is Not Null Begin if @Type = 0 Set @strReturn = @wd if @Type = 1 Begin If @wd = 1 Set @strReturn='星期日' If @wd = 2 Set @strReturn='星期一' If @wd = 3 Set @strReturn='星期二' If @wd = 4 Set @strReturn='星期三' If @wd = 5 Set @strReturn='星期四' If @wd = 6 Set @strReturn='星期五' If @wd = 7 Set @strReturn='星期六' End End Return @strReturn End GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO
select * from tb where DateDiff(ww ,sDay ,GetDate()) = 0
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GOALTER Function getWeekDay(@Date as DateTime ,@Type as int)
Returns varchar(10)
As
Begin
Declare @wd as int ,@strReturn as varchar(10)
set @wd = DatePart(dw ,@Date)
if @Type is Not Null
Begin
if @Type = 0
Set @strReturn = @wd
if @Type = 1
Begin If @wd = 1
Set @strReturn='星期日'
If @wd = 2
Set @strReturn='星期一'
If @wd = 3
Set @strReturn='星期二'
If @wd = 4
Set @strReturn='星期三'
If @wd = 5
Set @strReturn='星期四'
If @wd = 6
Set @strReturn='星期五'
If @wd = 7
Set @strReturn='星期六'
End
End
Return @strReturn
End
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
WHERE WEEK(day)=WEEK(now())