Datetime转换错误- varchar数据类型到datetime数据类型的转换导致值超出范围

-- 示例：假设表名为 my_table，列名为 my_date
UPDATE my_table
SET my_date = NULL
WHERE my_date NOT REGEXP '^[0-9]{4}-[0-9]{2}-[0-9]{2} [0-9]{2}:[0-9]{2}:[0-9]{2}$';

-- 示例：假设表名为 my_table，列名为 my_date
SELECT 
    TRY_CONVERT(DATETIME, my_date) AS converted_date
FROM my_table;

-- 示例：假设表名为 my_table，列名为 my_date
SELECT 
    STR_TO_DATE(my_date, '%Y-%m-%d %H:%i:%s') AS converted_date
FROM my_table;

import datetime

def convert_to_datetime(date_str):
    try:
        return datetime.datetime.strptime(date_str, '%Y-%m-%d %H:%M:%S')
    except ValueError:
        return None

# 示例：假设 date_str 是从数据库中读取的 VARCHAR 数据
date_str = '2023-10-05 12:34:56'
converted_date = convert_to_datetime(date_str)
if converted_date is not None:
    print(f'Converted Date: {converted_date}')
else:
    print('Conversion failed')