MySQL date format DD/MM/YYYY select query?

 

You can use STR_TO_DATE() to convert your strings to MySQL date values and ORDER BY the result:

ORDER BY STR_TO_DATE(datestring, '%d/%m/%Y')

However, you would be wise to convert the column to the DATE data type instead of using strings.

Comments

Post a Comment

Popular posts from this blog

Code for Google Translator for Website with Indian Languages

Paste this code onto your website Copy and paste the following code snippets onto every page you want to translate Place this meta tag before the closing </head>:- ————————————————————————————- <meta name=”google-translate-customization” content=”76732106efc70d8b-05ad2fc8af3e500b-ge0b18d68b0571536-16″ /> ————————————————————————————– Place this snippet where you’d like to display the Website Translator plugin on your page:- ————————————————————————————- <div id=”google_translate_element”></div><script type=”text/javascript”> function googleTranslateElementInit() { new google.translate.TranslateElement({pageLanguage: ‘en’, includedLanguages: ‘bn,en,gu,hi,kn,pa,ta,te,ur’, layout: google.translate.TranslateElement.InlineLayout.SIMPLE}, ‘google_translate_element’); } </script><script type=”text/javascript” src=”//translate.google.com/translate_a/element.js?cb=googleTranslateElementInit”></script>  
Read more