“time”:“202101”
},
{
“total”:0.0,
“count”:0.0,
“time”:“202012”
},
{
“total”:0.0,
“count”:0.0,
“time”:“202011”
},
{
“total”:0.0,
“count”:0.0,
“time”:“202010”
},
{
“total”:0.0,
“count”:0.0,
“time”:“202009”
},
{
“total”:0.0,
“count”:0.0,
“time”:“202008”
},
{
“total”:0.0,
“count”:0.0,
“time”:“202007”
},
{
“total”:0.0,
“count”:0.0,
“time”:“202006”
},
{
“total”:0.0,
“count”:0.0,
“time”:“202005”
}
],
“code”:null,
“msg”:null
}
近一月
SELECT
date_add( curdate(), INTERVAL ( cast( help_topic_id AS signed INTEGER ) - 30 ) DAY ) time