Here are a few question-based titles that fit the content of your article: * **Why does NodeJS display MySQL data in a different timezone than the database?** * **How to align NodeJS and MySQL timez

NodeJS MySQL Timezone Discrepancy

When fetching data directly from a MySQL database, the returned date is displayed in UTC, assuming the MySQL server is set to UTC. However, upon integrating MySQL with NodeJS, the data is retrieved in the local timezone, UTC 2 in this case. Understanding this discrepancy is crucial for maintaining synchronization between database and application time handling.

The underlying reason for this difference lies in the timezone handling mechanisms of MySQL and NodeJS. MySQL employs the system timezone for date and timestamp operations by default. In contrast, NodeJS uses the operating system's timezone settings unless explicitly overridden. This distinction leads to the deviation when querying MySQL with NodeJS.

To rectify this issue and align NodeJS with MySQL's UTC timezone, the connection configuration in NodeJS must be adjusted. Specifically, the "timezone" property needs to be specified. This parameter ensures that NodeJS maintains the same timezone as MySQL, regardless of the operating system's settings.

In the provided code snippet, the "timezone" property has been added to the MySQL connection configuration:

var db_config = {
  host: 'localhost',
  user: 'xxx',
  password: '',
  database: 'xxx',
  timezone: 'utc'  //<- This line resolves the issue
};

By incorporating this property, NodeJS is now configured to retrieve data in UTC, matching the behavior of MySQL. This adjustment eliminates the timezone discrepancy, ensuring consistent handling of timestamps between the database and the NodeJS application.

The above is the detailed content of Here are a few question-based titles that fit the content of your article: * **Why does NodeJS display MySQL data in a different timezone than the database?** * **How to align NodeJS and MySQL timez. For more information, please follow other related articles on the PHP Chinese website!