34,837
社区成员




select
(case when datediff(day,publishdate,getdate())<14 then 'red' else color end )as color,
publishdate
from
contents
select (case when datediff(day,publishdate,getdate())<14 then 'red' else color end )as color,
publishdate from contents
select
(case
when datediff(dd,publishdate,getdate())<=14 then 'red'
else color
end) as color,
publishdate
from
contents
when publishdate>getdate()-111 then 'RED'