无法将字符串转换为时间戳bigQuery

import re

def format_string_to_timestamp(date_str):
    # 假设输入字符串格式为 'DD/MM/YYYY HH:MM:SS'
    pattern = r'(\d{2})/(\d{2})/(\d{4}) (\d{2}):(\d{2}):(\d{2})'
    match = re.match(pattern, date_str)
    if match:
        day, month, year, hour, minute, second = match.groups()
        formatted_date_str = f'{year}-{month}-{day} {hour}:{minute}:{second}'
        return formatted_date_str
    else:
        raise ValueError("Invalid date string format")

# 示例
date_str = "31/12/2020 23:59:59"
formatted_date_str = format_string_to_timestamp(date_str)
print(formatted_date_str)  # 输出: 2020-12-31 23:59:59

SELECT TIMESTAMP('2020-12-31 23:59:59') AS timestamp;

WITH formatted_data AS (
  SELECT REGEXP_REPLACE('31/12/2020 23:59:59', r'(\d{2})/(\d{2})/(\d{4}) (\d{2}):(\d{2}):(\d{2})', r'\3-\2-\1 \4:\5:\6') AS formatted_date_str
)
SELECT TIMESTAMP(formatted_date_str) AS timestamp FROM formatted_data;