Sort:  
  • Trending
    • [-]
     7 years ago (edited) 
    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
    应该差不多这样？

    $0.72
    • Past Payouts $0.72
    • - Author $0.70
    • - Curators $0.01
    3 votes
    Reply
    [-]
     7 years ago  

    谢谢你，可不可以帮我改成可以算20小时前，因为我是在晚上8点发报告。