3 Answers

您好,我们查到问题,已回复您了,也回复到您企微上了。

数据库里通过查聊天记录,查到这个企微最近一次添加好友是在 15 号啊,16号没添加过好友。

SELECT to_char(to_timestamp(timestamp / 1000), 'YYYY-MM-DD HH24:MI:SS') AS added 
FROM chat_history 
WHERE wxid = '1688857328524363' AND msg::text LIKE '%我已经添加了你%'
ORDER BY timestamp DESC
LIMIT 100;

查 15 号新增的好友列表也能匹配上,那天添加了 25 个好友:

SELECT create_time, username 
FROM contacts 
WHERE wx_id = '1688857328524363' AND create_time >= '2023-12-15 00:00:00' 
ORDER BY create_time DESC;