How to display a sql date when using ORDER BY?

advertisements

I am trying to display the following dates in order from smallest to biggest.

They are stored this way.

02-12-15
02-11-13
12-20-12
12-12-12
05-12-17

This is the following code I use

"SELECT ledate FROM `points_bar` WHERE student_id = '$studentID' ORDER BY ledate ASC";

And this is what I want to transform it to.

02-11-13
12-20-12
12-12-12
02-12-15
05-12-17

Can someone please point out to me a possible solution or give me a little push?

Your dates are not in mysql supported date format. It treat as varchar. Change the SQL as follows should work.

"SELECT ledate FROM `points_bar` WHERE student_id = '$studentID' ORDER BY STR_TO_DATE(`ledate`, '%m-%d-%y') ASC";

See STR_TO_DATE

Related Articles

How to display the custom thumb when using fastScrollEnabled

I have a listview of countries in non-alphabetic order and started using fastscroll. I would like to display the country-flag when scrolling with fastscroll but it seems like the APIs has the FastScroll class as private so I cannot override it. Have

How to define the SQL mode when using the AOP?

I am trying to set SQL modes, I can't figure out how to do it using PDO. I am trying to set Traditional mode in MySQL and not allow invalid dates. Can anyone help?You can use the optional 'SESSION' variable when setting the sql_mode at runtime. That

How to save and store data when using Team Foundation Explorer?

I am working on a C# windows forms project with a friend and we are using TFS for our source control. The program we have written scrapes data off a couple of webpages at regular time intervals and this is updated to the UI. However, we would like to

How do I retrieve HttpServletRequest data when using Jersey

I know that this is an easy one if I am not using Jersey and would use something like this: Enumeration<String> params = request.getParameterNames(); while(params.hasMoreElements()){ String paramName = (String)params.nextElement(); System.out.printl

How to display the year entirely when using Java localization?

private String setDate(int day) { Calendar cal = Calendar.getInstance(); cal.setTime(new Date()); cal.add(Calendar.DATE, + day); DateFormat df = DateFormat.getDateInstance(DateFormat.SHORT, locale); String formattedDate = df.format(cal.getTime()); re

Store data when using Greasemonkey

Is there a good way to store an extensive amount of data when using Greasemonkey for when GM_setValue just doesn't cut it?Well here are the options: Setup a server to save the data for the user, and use xhr to create/edit/remove data (Google App Engi