SQL中 将DataTime 类型的数据以 Data类型读取 select DISTINCT DATE_FORMAT(date,'%Y-%m-%d') as '日期',left_footage as '左进尺',right_footage as '右进尺' from 工作面进尺