Question

How to format a date as YYYY-MM-DD hh:mm:ss in JavaScript

Answer 1

const d = new Date();

dateformat = [d.getFullYear(),
   			  d.getMonth()+1,
              d.getDate()].join('-')+' '+
             [d.getHours(),
              d.getMinutes(),
              d.getSeconds()].join(':');

console.log(dateformat);

  
  
  
  
/*
run:
  
"2022-4-12 9:2:32"
  
*/

 

70+ SQL courses for beginners and professionals

Answer 2

function padzero(n) {
	return n.toString().padStart(2, '0');
}

function formatDate(date) {
    return (
      [
        date.getFullYear(),
        padzero(date.getMonth() + 1),
        padzero(date.getDate()),
      ].join('-') + ' ' +
      [
        padzero(date.getHours()),
        padzero(date.getMinutes()),
        padzero(date.getSeconds()),
      ].join(':')
    );
}

console.log(formatDate(new Date('Apr 05, 2023 09:05:18')));

  
  
  
  
/*
run:
  
"2023-04-05 09:05:18"
  
*/

 

70+ SQL courses for beginners and professionals