SQL日期相减，根据得到的值来更新相应的字段

[guoguo1]

UPDATE customer
SET name = '公司客户'
WHERE (now -
(SELECT TOP 1 time
FROM content
WHERE customerid = 1
ORDER BY id DESC > 1)

提示说“>”附近有错误

[good2speed]

UPDATE customer
SET name = '公司客户'
WHERE (now -
(SELECT TOP 1 time
FROM content
WHERE customerid = 1
ORDER BY id DESC )> 1)

[guoguo1]

UPDATE customer
SET name = '公司客户'
WHERE (now -
(SELECT TOP 1 time
FROM content
WHERE customerid = 1
ORDER BY id DESC )> 1)


现在说我的now无效，now是系统当前的时间

[WangZWang]

UPDATE customer
SET name = '公司客户'
WHERE (GetDate()-(SELECT TOP 1 time
FROM content WHERE customerid = 1
ORDER BY id DESC)>1)