UNIX_TIMESTAMP(DATE_FORMAT(ssr.action_time,'%Y-%m-%d'))

// 蓝凤凰-查询动态瞬感数据

public static String sgSugarRecord = "select ssr.patient_id,UNIX_TIMESTAMP(DATE_FORMAT(ssr.action_time,'%Y-%m-%d')) as time,ba.access_id from sg_sugar_record ssr,service_doctor_patient sdp,bybe_account ba"

+ " where ssr.patient_id=sdp.patient_user_id and sdp.doctor_user_id=ba.user_id order by ssr.id desc limit ?";

不知道有没有更合理的函数，先实现，以后再优化。