从字符串SQL BigQuery中解析年份和月份

import re

def extract_year_and_month(sql_string):
    pattern = r'(\d{4})-(\d{2})'  # 匹配形如yyyy-mm的日期格式
    match = re.search(pattern, sql_string)
    if match:
        year = match.group(1)
        month = match.group(2)
        return year, month
    else:
        return None

sql_string = "SELECT * FROM my_table WHERE date = '2022-10-15'"
year, month = extract_year_and_month(sql_string)
print("Year:", year)
print("Month:", month)

Year: 2022
Month: 10