How to Convert JavaScript Date Time to MySQL Datetime and Handle Minute Adjustments?

Convert JavaScript Date Time to MySQL Datetime

When working with dates and times across different systems, it's essential to be able to convert between JavaScript and MySQL datetime formats. Here's a detailed solution to this conversion:

Conversion to MySQL Datetime:

To convert a JavaScript Date object to a MySQL datetime string, the following code can be used:

var date;
date = new Date();
date = date.getUTCFullYear() + '-' +
    ('00' + (date.getUTCMonth()+1)).slice(-2) + '-' +
    ('00' + date.getUTCDate()).slice(-2) + ' ' +
    ('00' + date.getUTCHours()).slice(-2) + ':' +
    ('00' + date.getUTCMinutes()).slice(-2) + ':' +
    ('00' + date.getUTCSeconds()).slice(-2);
console.log(date);

This code generates a datetime string in the format that MySQL recognizes.

Adding Minutes to JavaScript Datetime:

To add a specific number of minutes to a JavaScript Date object, you can use the following code:

date.setMinutes(date.getMinutes() + minutesToAdd);

Passing to MySQL Datetime:

Once you have added the required number of minutes to the JavaScript Date object, you can convert it to a MySQL datetime string using the same code as shown in the first conversion step.

Advanced Options:

For more advanced use cases, such as controlling the timezone, consider using libraries like Moment.js or Fecha. Here are examples:

// Moment.js
require('moment')().format('YYYY-MM-DD HH:mm:ss');

// Fecha
require('fecha').format('YYYY-MM-DD HH:mm:ss');

The above is the detailed content of How to Convert JavaScript Date Time to MySQL Datetime and Handle Minute Adjustments?. For more information, please follow other related articles on the PHP Chinese website!