nodejs format unix date to sql date

Sorann answered on February 28, 2023 Popularity 1/10 Helpfulness 8/10

answer nodejs format unix date to sql date

nodejs format unix date to sql date

Comment

/**
 * @brief convert a unix timestamp to a SQL date
 * @param unixTimestamp
 * @returns {String} the date in the format YYYY-MM-DD hh:mm:ss
 * @example unixTimeToSQLDate(1091040026000) => "2004-07-28 18:40:26"
 */
unixTimeToSQLDate(unixTimestamp){
  return new Date(unixTimestamp).toISOString().slice(0, 19).replace('T', ' ');
}

if you don't want the time and just want the date replace .slice(0, 19) with .slice(0, 10)

Popularity 1/10 Helpfulness 8/10 Language javascript

Source: stackoverflow.com

Tags: date format javascript sql unix

Link to this answer
Share Copy Link

Contributed on Feb 28 2023

Sorann

0 Answers Avg Quality 2/10

nodejs format unix date to sql date

Contents

More Related Answers

nodejs format unix date to sql date

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.