select timestampdiff(SECOND,timestamp(t.LAST_LOGIN_TIME),timestamp(NOW())) from cfg_user t second 可以换 day select timestampadd(day, 1, '2008-08-08 08:00:00');