分钟数据序号转分钟

    server = ‘127.0.0.1‘
    database = ‘Stock‘
    username = ‘sa‘
    password = ‘root‘

    index_list = list(range(1, 121))



    cnxn = pyodbc.connect(
        ‘DRIVER={ODBC Driver 17 for SQL Server};SERVER=‘ + server + ‘;DATABASE=‘ + database + ‘;UID=‘ + username + ‘;PWD=‘ + password)
    sw_init_date = datetime(2021, 1, 1, 9, 30, 0)
    xw_init_date = datetime(2021, 1, 1, 13, 0, 0)

    for i_sw in index_list:
        i_minute = sw_init_date + timedelta(minutes=i_sw)
        i_minute_value = ‘ ‘ + i_minute.strftime(‘%H:%M:%S‘)
        sql = ‘INSERT INTO [dbo].[minute_dict]                     ([minute_index]                     ,[minute_value])                VALUES({0},\‘{1}\‘)‘.format(i_sw,i_minute_value)
        cnxn.execute(sql)

    for i_xw in index_list:
        i_minute = xw_init_date + timedelta(minutes=i_xw)
        i_minute_value = ‘ ‘+i_minute.strftime(‘%H:%M:%S‘)
        sql = ‘INSERT INTO [dbo].[minute_dict]                             ([minute_index]                             ,[minute_value])                        VALUES({0},\‘{1}\‘)‘.format(i_xw, i_minute_value)

        cnxn.execute(sql)
    cnxn.commit()