日期格式转换 date_format(lcsi.SIGN_TIME,'%Y/%m/%d') eg:select date_format(a.SIGN_TIME,'%Y/%m/%d') from asd a 时区转换 sql增加8小时: date_add(startTime,INTERVAL 8 HOUR) eg:select date_add( date_format(a.FINISHDATE,'%Y-%m-%d %H:%i:%s'),INTERVAL 8 HOUR) from asd a