Convert MySql DateTime stamp into JavaScript’s Date format

by

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(Date.UTC(t[0], t[1]-1, t[2], t[3], t[4], t[5]));

console.log(d);
// -> Wed Jun 09 2010 14:12:01 GMT+0100 (BST)

Fair warning: this assumes that your MySQL server is outputting UTC dates (which is the default, and recommended if there is no timezone component of the string).

More Related Contents:

  1. Convert UTC date time to local date time
  2. Converting milliseconds to a date (jQuery/JavaScript)
  3. Moment js date time comparison
  4. How to get the exact local time of client?
  5. Convert normal date to unix timestamp
  6. Sort a string date array
  7. Get current date in DD-Mon-YYY format in JavaScript/Jquery
  8. Age from Date of Birth using JQuery
  9. Inconsistent behavior of toLocaleString() in different browser
  10. Parsing Date from webservice
  11. Best JavaScript Date Parser & Formatter? [closed]
  12. how to update time regularly?
  13. Hot to get incomplete datetime-local input values
  14. How do I execute a PHP query on select option choice using AJAX?
  15. How do you get a timestamp in JavaScript?
  16. Stop form refreshing page on submit
  17. Rails 5: how to use $(document).ready() with turbo-links
  18. Why can’t we have return in the ternary operator?
  19. Throttle event calls in jQuery
  20. jQuery get the location of an element relative to window
  21. Test if links are external with jQuery / javascript?
  22. Change iframe src by clicking a link
  23. How to generate a thumbnail image after adding an image inside an input type=”file” in a form and submitting them both on the same form
  24. Can you have a JavaScript hook trigger after a DOM element’s style object changes?
  25. jQuery x y document coordinates of DOM object
  26. How do I capture a key press (or keydown) event on a div element?
  27. Remove URL parameters without refreshing page
  28. How to properly unload/destroy a VIDEO element
  29. Html duplicated ID
  30. .js.erb VS .js

Leave a Comment