SELECT
COUNT(*)
FROM
TxComments
WHERE
timestamp >= DATEADD(day, -1, GETDATE())
AND title <> ''
and json_metadata LIKE '%"cn"%'
The number of posts with "cn" tag in the last 24 hrs
应该差不多这样？
You are viewing a single comment's thread from:
谢谢你，可不可以帮我改成可以算20小时前，因为我是在晚上8点发报告。