dongniaoli1822 2013-04-10 10:09
浏览 49
已采纳

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

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 enter image description here

Code

SELECT * 
FROM data_feeds
WHERE username =  'davidjhume@gmail.com'
AND gadget_data_type =  'Weighin'
ORDER BY STR_TO_DATE( date_time,  '%D, %j %M %Y %H:%i:%s' ) DESC 
LIMIT 1
  • 写回答

2条回答 默认 最新

  • duanchi4544 2013-04-10 10:18
    关注

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

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题？