• code snippets
  • all code snippets/
  • popular code snippets/
  • your code snippets
• extras
• blog
• about snipplr

• Big /
• Small

Posted By

jonniespratley on 07/24/09

Tagged

mysql timestamp

Versions (?)

07/24/09 04:40am

Who likes this?

1 person have marked this snippet as a favorite

thastyle

 / Published in: JavaScript

 

/**
 * I make a mysql date timestamp
 * @deprecated - Datepicker used instead
 * @param {Object} dateobj - a date
 */
function jps_makeTimestamp( dateobj )
{
	var date = new Date( dateobj );
	var yyyy = date.getFullYear();
    var mm = date.getMonth() + 1;
    var dd = date.getDate();
    var hh = date.getHours();
    var min = date.getMinutes();
    var ss = date.getSeconds();
 
	var mysqlDateTime = yyyy + '-' + mm + '-' + dd + ' ' + hh + ':' + min + ':' + ss;
 
    return mysqlDateTime;
}

Report this snippet   Tweet

Comments

Subscribe to comments

Posted By: craniumslows on April 30, 2011

I modified this a bit for my purposes. I know you advised of deprecation just a heads up for future visitors

//Thanks http://snipplr.com/view.php?codeview&id=17418 function makeTimestamp( ) { //modified to have param dateobj be optional and default be current date / time if (!arguments[0]) { var dateobj = new Date(); } else { var dateobj = arguments[0]; } var date = new Date( dateobj ); var yyyy = date.getFullYear(); var mm = date.getMonth() + 1; if (mm < 10 ) { mm = "0" + mm; } var dd = date.getDate(); if (dd < 10 ) { dd = "0" + dd; } var hh = date.getHours(); if (hh < 10 ) { hh = "0" + hh; } var min = date.getMinutes(); if (min < 10 ) { min = "0" + min; } var ss = date.getSeconds(); if (ss < 10 ) { ss = "0" + ss; }

var mysqlDateTime = yyyy + '-' + mm + '-' + dd + ' ' + hh + ':' + min + ':' + ss;

return mysqlDateTime;

}