python格式化时间

import datetime
import os


def get15day():
    today = datetime.date.today()
    day15 = datetime.timedelta(days=15)
    day_before_15 = today - day15
    return day_before_15


today = datetime.date.today().strftime('%Y_%m_%d')
tbname = 'cpu_info_' + str(today)
oldtbname = 'cpu_info_' + str( get15day().strftime('%Y_%m_%d'))

print(tbname)
print(oldtbname)

sql = '''create table {}(
        id int auto_increment comment 'main key', 
        IP varchar(20) default '' comment 'IP Address', 
        cpu tinyint  default 0 comment 'cpu info(c)', 
        domain varchar(70) default '' comment 'domain address', 
        primary key(id))
        engine =innodb charactacter set utf8 comment '前台CPU信息';'''.format(tbname)

command = 'mysql --login-path=localhost -D jd_dbmonitor -e {}'.format(sql)

print(datetime.date.today())
#os.system(command)