将nvarchar日期(DD/MM/YYYY)转换为日期期间(YYYY_MM)

def convert_date_to_period(nvarchar_date):
    day, month, year = nvarchar_date.split('/')
    day = int(day)
    month = int(month)
    year = int(year)

    period_year = str(year)
    period_month = str(month).zfill(2)
    period = period_year + '_' + period_month

    return period

# 示例用法
nvarchar_date = "25/12/2022"
period = convert_date_to_period(nvarchar_date)
print(period)  # 输出：2022_12