SELECT
t2.creds,
t1.time,
t1.entry
FROM
wp_mycred_log t1,
--先将要取的积分求和
( SELECT SUM( creds ) creds FROM wp_mycred_log WHERE user_id = 1 ) t2
WHERE
t1.user_id = 1
--根据时间排序
ORDER BY
t1.time DESC
LIMIT 0,1;
mysql时间处理 utc时间转化为当地时间(多伦多时间),时间格式化
SELECT
creds Pionts,
--时间戳转化为时间,在采用多伦多的时区将utc时间转化为多伦多时间
CONVERT_TZ( from_unixtime( time ), '+00:00', '-5:00' ) Date,
entry Entry
FROM
wp_mycred_log
WHERE
user_id = 7;
SELECT
creds Pionts,
--最终将时间格式化成为英文时间
date_format( CONVERT_TZ( from_unixtime( time ), '+00:00', '-5:00' ), '%d-%m-%Y %H:%i' ) Date,
entry Entry
FROM
wp_mycred_log
WHERE
user_id = 7