How to convert MySQL DATETIME value to json format in JavaScript

Question

I want to convert the DATETIME value retrieved from MySQL to JSON.

Tue Aug 19 2014 16:55:01 GMT+0800 (CST)

The resulting JSON should look like this:

{'year': yyyy, 'month': MM, 'day': dd, 'hour': hh, 'minute': mm, 'second': ss, 'GMT': GMT}

Regular expression seems to be too complex. I don't know how to perform the conversion.

capture groups using parenthesis (...) and replace with $index in final JSON string — Braj
– Braj, Commented Aug 19, 2014 at 9:46

sri · Accepted Answer · 2014-08-19 09:58:35Z

4

You could do something like:

var d = new Date("Tue Aug 19 2014 16:55:01 GMT+0800 (CST)");
var year = d.getFullYear();
var date = d.getDate();     //so on so forth.

All the date objects are explained here. These variables can then be used in your json object.

answered Aug 19, 2014 at 9:58

sri

3382 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

hex494D49 · Accepted Answer · 2014-08-19 10:28:28Z

1

It can be done using regular expression as well. Like in the following snippet.

var s = 'Tue Aug 19 2014 16:55:01 GMT+0800 (CST)';
var p = /(\w+)\s(\w+)\s(\d+)\s(\d+)\s(\w+):(\d+):(\d+)\s(\w+).*/;

console.log(s.replace(p, "{'year': $4, 'month': $2, 'day': $1, 'hour': $5, 'minute': $6, 'second': $7, 'GMT': $8}"));

Working jsBin

edited Aug 19, 2014 at 10:28

answered Aug 19, 2014 at 10:17

hex494D49

9,2453 gold badges41 silver badges50 bronze badges

Collectives™ on Stack Overflow

How to convert MySQL DATETIME value to json format in JavaScript

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related