我应该如何根据date_time从数据库中按降序获取数据？

Question

Problem I have the last data entry in date_time for 9th of april 2013 whereas when I try to fetch in descending order from the database it is giving me 8th April 2013. Please see the image and Code below. Any help will be appriciated.

Database

Code

SELECT * 
FROM data_feeds
WHERE username =  '[e-mail]'
AND gadget_data_type =  'Weighin'
ORDER BY STR_TO_DATE( date_time,  '%D, %j %M %Y %H:%i:%s' ) DESC 
LIMIT 1

Answer 1

Format string is broken, try: '%a, %e %b %Y %H:%i:%s'