SELECT
taibaoshujubiao.shoujihao AS shoujihao,
taibaoshujubiao.zuoxiguishu AS zuoxiguishu,
taibaoshujubiao.xiafariqi AS xiafariqi,
taibaoshujubiao.shujulaiyuan AS shujulaiyuan,
taibaoshujubiao.shifouchudan AS shifouchudan,
taibaoshujubiao.cheshang AS cheshang,
taibaoshujubiao.toubaoming AS toubaoming,
taibaoshujubiao.beibaoming AS beibaoming,
length( taibaoshujubiao.chepai ) AS LENGTH(chepai),((
to_days( taibaoshujubiao.qibaoriqi ) - to_days(
now())) + 1
) AS DATEDIFF(qibaoriqi,NOW())+1
FROM
taibaoshujubiao
WHERE
((((
to_days( taibaoshujubiao.qibaoriqi ) - to_days(
now())) + 1
) = ‘66’
)

重要的是这句

((
to_days( taibaoshujubiao.qibaoriqi ) - to_days(
now())) + 1
) AS DATEDIFF(qibaoriqi,NOW())+1