Q:

JQuery format date from MySQL.  How? 

I have the following date format in a MySQL database and was wondering what would be the best method to reformat this date and output what I have in mind. 
MySQL: 2012-04-12
Desired Output: Thursday, April 12 2012
Perhaps I could format it in the MySQL query? 
Or with Java script? 
Could anyone provide a sample of both so I could learn? 

A:

Try moment.js
e.g. var day = moment("2012-04-12", "DDDD, MMMM DD YYYY");

A:

You have a lot of ways to do this:

With MySQL, using DATE_FORMAT http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html#function_date-format
With PHP, using strtotime and date: date('J, M d Y', strtotime($yourdate))
With JavaScript, splitting the date at "-" and then creating your date again with new Date()
Also (like explained by t0s6i), with JavaScript, you can use the library momentjs to do something like this: date = moment("2012-04-12", "DDDD, MMMM DD YYYY");.