MySQL date to Javascript date

Question

I get a date from MySQL in the following format:

Sat Dec 10 1988 19:40:16 GMT+0200 (South Africa Standard Time)

I want to convert this to a Javascript date so that I can easily supply JSON timestamps for data readings (Probably in the format YYYY-MM-DD:HH:mm:ss). How can I do that?

which programming language are you using ? and what is the problem with current format ? — Ravi
– Ravi, Commented Dec 24, 2018 at 7:34
Possible duplicate of Converting a string to a date in JavaScript — Herohtar
– Herohtar, Commented Dec 24, 2018 at 7:34
I'm using Javascript, and I want to get it into a Javascript Date object. — Cornel Verster
– Cornel Verster, Commented Dec 24, 2018 at 7:35
You can't access db using plain javascript AFAIK. You should have some server side programming — Ravi
– Ravi, Commented Dec 24, 2018 at 7:35
I access MySQL using Javascript's MySQL library, but that is irrelevant. I want to store the String date format I posted into a Javascript Date object. — Cornel Verster
– Cornel Verster, Commented Dec 24, 2018 at 7:37

Brad · Accepted Answer · 2018-12-24 07:38:36Z

1

All you need to do is create a new Date with this string as the parameter for the constructor:

new Date('Sat Dec 10 1988 19:40:16 GMT+0200 (South Africa Standard Time)');

This works because it's a format compatible with RFC2822. See also: https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Global_Objects/Date

answered Dec 24, 2018 at 7:38

Brad

164k57 gold badges380 silver badges559 bronze badges

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

Comments

Deepak Preman · Accepted Answer · 2018-12-24 07:48:44Z

1

This will give you exactly what you want.

var d = new Date('Sat Dec 10 1988 19:40:16 GMT+0200 (South Africa Standard Time)');


formated_date  = [d.getMonth()+1,d.getDate(),d.getFullYear()].join('/')+' '+
                 [d.getHours(),d.getMinutes(),d.getSeconds()].join(':');

answered Dec 24, 2018 at 7:48

Deepak Preman

1131 silver badge11 bronze badges

Collectives™ on Stack Overflow

MySQL date to Javascript date

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related