python sqlite 时间查询

conn = get_conn(sqlite_path+os.sep+dbfile)table_sql = "select name from sqlite_master where type='table' order by name"cu = get_cursor(conn)cu.execute(table_sql)tablenames = cu.fetchall()# print('tablenames:',tablenames) # [('sh600152',), ('sh600228',),..]for symbol_table in tablenames:    fetchall_sql = '''SELECT * FROM ''' + symbol_table[0] + """ where((strftime("%H",time)='09')and(strftime("%M",time)>='30')and(strftime("%M",time)<'31'))"""    print(fetchall_sql)    cu.execute(fetchall_sql)    data = cu.fetchall()    print (data)