dzm dzm - 7 months ago 198
Javascript Question

Convert MySql DateTime stamp into JavaScript's Date format

Does anyone know how I can take a MySQL

datetime
data type value, such as
YYYY-MM-DD HH:MM:SS
and either parse it or convert it to work in JavaScript's
Date()
function, for example:- Date('YYYY, MM, DD, HH, MM, SS);

Thank you!

Answer

Some of the answers given here are either overcomplicated or just will not work (at least, not in all browsers). If you take a step back, you can see that the MySQL timestamp has each component of time in the same order as the arguments required by the Date() constructor.

All that's needed is a very simple split on the string:

// Split timestamp into [ Y, M, D, h, m, s ]
var t = "2010-06-09 13:12:01".split(/[- :]/);

// Apply each element to the Date function
var d = new Date(t[0], t[1]-1, t[2], t[3], t[4], t[5]);

console.log(d);
// -> Wed Jun 09 2010 13:12:01 GMT+0100 (GMT Daylight Time)
Comments