extends javascript's Date object with four new methods designed to assist with handling MySQL Timestamps.
toMysqlDate & toMysqlUTCDate methods:
var date = new Date();
date.toMysqlDate(); // Outputs: '2016-08-28 22:45:37' (String)
date.toMysqlUTCDate(); // Outputs: '2016-08-28 19:45:37' (String)
fromMysqlDate & fromMysqlUTCDate methods:
Date.fromMysqlDate('1979-03-28 23:45:37'); // Outputs: (Date object)
Date.fromMysqlUTCDate('2013-03-28 11:11:52'); // Outputs: (Date object)
npm install mysqldate
Usage:
require('mysqldate');
bower install mysqldate
Insert before your scripts:
<script src="bower_components/mysqldate/mysqldate.js" type="text/javascript"></script>