Format Date in JavaScript

To convert today's date to a MySQL friendly date string like 2012-06-23

var today = new Date().toISOString().slice(0, 10);

Keep in mind that the above solution does not take into account your timezone offset.

You might consider using this function instead:

function toJSONLocal (date) {
    var local = new Date(date);
    local.setMinutes(date.getMinutes() - date.getTimezoneOffset());
    return local.toJSON().slice(0, 10);
}

This will give you the correct date in case you are executing this code around the start/end of the day.

• Example: http://jsfiddle.net/simo/sapuhzmm/ 
• Date.toISOString 
• Date.toJSON 
• String.slice