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>
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