Date Formate change from Y-m-d to d-m-Y in jquery | javascript | js
var dob=$("#dob").val();
var new_dob=dob.split("-").reverse().join("-");
$("#dob").val(new_dob);
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