Select cardID 卡号,
customerName 姓名,
curID 货币,
openDate 开户日期,
openMoney 开户金额,
balance 余额
From cardInfo,userInfo
Where cardInfo.customerID =userInfo.customerID and
datepart(week,openMoney)=datepart(week,getdate())
customerName 姓名,
curID 货币,
openDate 开户日期,
openMoney 开户金额,
balance 余额
From cardInfo,userInfo
Where cardInfo.customerID =userInfo.customerID and
datepart(week,openMoney)=datepart(week,getdate())
Declare @Monday datetimeSelect @Monday=DATEADD(wk, DATEDIFF(wk,0,getdate()), 0)----获取本周星期一的日期Select cardID 卡号,
customerName 姓名,
curID 货币,
openDate 开户日期,
openMoney 开户金额,
balance 余额
From cardInfo,userInfo
Where cardInfo.customerID =userInfo.customerID and
openDate between @Monday and DATEADD(dd,7,@Monday)
Select cardID 卡号,
customerName 姓名,
curID 货币,
openDate 开户日期,
openMoney 开户金额,
balance 余额
From cardInfo,userInfo
Where cardInfo.customerID =userInfo.customerID and
datename(wk,openMoney) = datename(wk,getdate())-- ???
--------查询 本周内开户的用户
Declare @Monday datetimeSelect @Monday=DATEADD(wk, DATEDIFF(wk,0,getdate()), 0)----获取本周星期一的日期Select cardID 卡号,
customerName 姓名,
curID 货币,
openDate 开户日期,
openMoney 开户金额,
balance 余额
From cardInfo,userInfo
Where cardInfo.customerID =userInfo.customerID and
openDate between @Monday and DATEADD(dd,7,@Monday)