MySQL格式问题

Question

我有一个 MySQL 查询:

SELECT DATE_FORMAT(CONVERT_TZ(`StartTime`, '+0:00', `timeZone`),'%b %d, %Y %h:%i %p') as start, 
       DATE_FORMAT(CONVERT_TZ(`endTime`, '+0:00', `timeZone`),'%b %d, %Y %h:%i %p') as end 

输出为

start = Nov 09, 2015 06:40 PM
end = Nov 09, 2015 07:10 PM

但我想要以下格式的输出:Nov 09, 2015 06:40 PM EST 而不是 Nov 09, 2015 06:40 PM

Answer 1

因为你已经有了时区，你可以像这样将它插入到第二个 DATE_FORMAT() 参数中:

SELECT DATE_FORMAT(CONVERT_TZ(`StartTime`, '+0:00', `timeZone`),CONCAT'%b %d, %Y %h:%i %p ', timeZone)) as start, 
  DATE_FORMAT(CONVERT_TZ(`endTime`, '+0:00', `timeZone`), CONCAT('%b %d, %Y %h:%i %p ', timeZone)) as end
 FROM appointments
 WHERE CounselorID = 225 AND AvaliableStatus = '0' AND counselorsStatus = 0 AND Type = 2