How do I convert a JavaScript date to a MySQL datetime format?

Question

For example, my JavaScript date function returns:

Tue Apr 29 2014 14:40:00 GMT-0500 (Central Daylight Time)

Is there any function I can use to convert this into the proper DateTime format to save this in MySQL? It should look like:

2014-04-29 14:40:00

your server side script used to add the data to mysql should be able to do it and convert to proper date format before adding to mysql. — Abhik Chakraborty, Apr 24 '14 at 19:51
Oh, I didn't realize DateTime was the same as TimeStamp - thought they were different formats. — cg22, Apr 24 '14 at 19:53
http://www.w3schools.com/jsref/jsref_obj_date.asp....Google is your friend. — nFinIt_loop, Apr 24 '14 at 19:55

score 0 · Answer 1 · edited Sep 07 '14 at 15:18

0

try this:

or if you want to give format to the

edited Sep 07 '14 at 15:18

BenMorel

answered Apr 24 '14 at 20:03

khan xada

1 Answers1