select bzsjsk = CASE WHEN datename(dw, getdate()) like '星期一' THEN
SELECT dtsjsk
FROM xmxjsk
WHERE tbsj > dateadd(day, - 1, getdate())AND tbsj <= dateadd(day, 6, getdate())
提示信息为
消息 156,级别 15,状态 1,第 2 行
关键字 'SELECT' 附近有语法错误。
我是想通过今天 获取本周的时间段内的dtsjsk 大侠帮忙看下啊
SELECT dtsjsk
FROM xmxjsk
WHERE tbsj > dateadd(day, - 1, getdate())AND tbsj <= dateadd(day, 6, getdate())
提示信息为
消息 156,级别 15,状态 1,第 2 行
关键字 'SELECT' 附近有语法错误。
我是想通过今天 获取本周的时间段内的dtsjsk 大侠帮忙看下啊
(SELECT dtsjsk
FROM xmxjsk
WHERE tbsj > dateadd(day, - 1, getdate())AND tbsj <= dateadd(day, 6, getdate()))
end
FROM xmxjsk
WHERE datename(dw, getdate()) like '星期一'
and tbsj > dateadd(day, - 1, getdate())AND tbsj <= dateadd(day, 6, getdate())
(
SELECT dtsjsk
FROM xmxjsk
WHERE tbsj > dateadd(day, - 1, getdate())AND tbsj <= dateadd(day, 6, getdate()) )END
if datename(dw, getdate()) like '星期一'
SELECT dtsjsk
FROM xmxjsk
WHERE tbsj > dateadd(day, - 1, getdate())AND tbsj <= dateadd(day, 6, getdate())
?
SELECT dtsjsk
FROM xmxjsk
WHERE datepart(week,tbsj)=datepart(week,getdate())
and datepart(year,tbsj)=datepart(year,getdate())
FROM xmxjsk
WHERE datediff(dw, getdate())=0 --获取本周的数据