mysql 日期字段排序_mysql – 日期字段在sql中没有正确排序

以下是我的搜索结果(by cruise_date)：

CRUISE_DATE DAYS_TILL_CRUISE NAME

10/13/2012 29 Octobertfest

10/20/2012 36 Rare Air Show,

10/20/2012 36 Bugs and Bratz

11/10/2012 57 Fall Color Super Cruise

11/10/2012 57 Club Cruise-In to Desoto State Park

9/22/2012 8 Bugs on the Bayou

9/23/2012 9 Hot Dogs and Hot Rods

请注意,日期是十月,十一月,九月.

这是我的sql语句：

SELECT

DATE_FORMAT(cruise_date, '%c/%e/%Y') AS cruise_date,

DATEDIFF(cruise_date, CURDATE()) AS days_till_cruise,

NAME

FROM

`cruise`

WHERE

`cruise_date` >= '2012-09-14'

ORDER BY

`cruise_date`

为什么我的日期不能正确排序？