Parsing MySQL TIME in javascript

Question

I get a MySQL TIMESTAMP and MySQL TIME from via an ajax request. What is a good way to add the time to the timestamp in javascript?

Given 2013-11-06 15:46:03 and 1:00:00, the result should be 2013-11-06 16:46:03. Below, I have a partial solution:

a = "2013-11-06 15:46:03";
b = "1:00:00";

//convert a to timestamp (in milliseconds)
a_ms = Date.parse(a);

//convert b to milliseconds
b_vals = b.split(':');
b_ms = 360000*bvals[0] + 60000*bvals[1] + 1000*bvals[2];

//add and convert to Date object
c = new Date(a_ms + b_ms); //Wed Nov 06 2013 15:52:03 GMT-0500 (EST)

Main question: Is there a better way to do this? For example, is there a better way to convert b to milliseconds? [edit: No libraries please. No matter how small, I wouldn't consider it "better" than parsing it myself in one line.]
Secondary question: How do I output c as YYYY-MM-DD HH-MM-SS?

homtg · Accepted Answer · 2013-11-08 22:19:06Z

5

Let a lib do that for you, like http://momentjs.com/

var a = moment("2013-11-06 15:46:03");
var b = moment(a).add('hours', 1);
var c = b.format("YYYY-MM-DD HH-mm-ss");

Edit to fit your requirement of also parsing the date difference:

var a = moment("2013-11-06 15:46:03");
var b = moment("1:00:00", "HH:mm:ss");
var c = moment(a).add(b).format("YYYY-MM-DD HH-mm-ss");

edited Nov 8, 2013 at 22:19

answered Nov 8, 2013 at 21:52

homtg

1,9991 gold badge15 silver badges20 bronze badges

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

3 Comments

jmilloy Over a year ago

The library could help, but your example doesn't solve the problem I supplied. Can moment take the string '1:00:00' and add it to a timestamp? It doesn't look like it.

homtg Over a year ago

there it is, nearly too easy to be true ;)

Kaya Toast Over a year ago

This example should be in the docs (and among its first few lines) of moment.js ... it is not immediately obvious on that site that moment.js can "take in" some date format and convert it to another format.

Tom · Accepted Answer · 2013-11-08 21:52:03Z

2

For your second question, I'd recommend looking at these sites, they help me alot: Working with Dates and 10 ways to format time and date using JavaScript

P.S. I'd make it a comment, but yeah. rep.

answered Nov 8, 2013 at 21:52

Tom

3322 silver badges15 bronze badges

2 Comments

jmilloy Over a year ago

I didn't downvote you, but you should fix your answer by supplying the actual answer, with code.

Tom Over a year ago

Well I would've posted this as a comment, but since there's this rule that I CAN'T.. Think it's strange you can post an answer but not a comment anyway, only trying to help here. Should stop doing that since I just get downvoted.

Collectives™ on Stack Overflow

Parsing MySQL TIME in javascript

2 Answers 2

3 Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related