返回最大值和按月分组的日期+时间值

// 假设有一个日期+时间值的数据集合
const data = [
  '2022-01-01 10:00:00',
  '2022-01-15 12:00:00',
  '2022-02-05 08:30:00',
  '2022-02-20 09:45:00',
  '2022-03-10 14:20:00',
  '2022-03-25 16:30:00'
];

// 找到最大值
const max = new Date(Math.max.apply(null, data.map(date => new Date(date))));

// 按月分组
const groupedData = data.reduce((result, date) => {
  const month = new Date(date).getMonth();
  if (!result[month]) {
    result[month] = [];
  }
  result[month].push(date);
  return result;
}, {});

console.log('最大值:', max);
console.log('按月分组:', groupedData);

import mysql.connector

# 连接数据库
cnx = mysql.connector.connect(user='username', password='password', host='localhost', database='database_name')
cursor = cnx.cursor()

# 查询最大值
query = "SELECT MAX(date_time_column) FROM table_name"
cursor.execute(query)
max_value = cursor.fetchone()[0]

# 按月分组查询
query = "SELECT MONTH(date_time_column), date_time_column FROM table_name GROUP BY MONTH(date_time_column)"
cursor.execute(query)
grouped_data = {}
for month, date_time in cursor:
    if month not in grouped_data:
        grouped_data[month] = []
    grouped_data[month].append(date_time)

cursor.close()
cnx.close()

print('最大值:', max_value)
print('按月分组:', grouped_data)