2011-04-21

Mysql 文字轉日期排序

SELECT STR_TO_DATE(concat(AC_Month,'/', AC_Year + 1911), '%m/%Y') as dd,s. *
FROM tndg_activities_month AS m, tndg_activities_service AS s
WHERE s.A_SERIALNO = m.SERIALNO
AND s.MemberID = '??'
ORDER BY dd

沒有留言: