gistfile1.py

#!/usr/bin/env python

import datetime

numdays = 180

base = datetime.datetime.today()
date_list = [base - datetime.timedelta(days=x) for x in range(0, numdays)]
for date in date_list:
    y1 = date.year
    m1 = date.month
    d1 = date.day
    date2 = date + datetime.timedelta(days=1)
    y2 = date2.year
    m2 = date2.month
    d2 = date2.day
    print "PARTITION  day_%04d%02d%02d VALUES LESS THAN ( UNIX_TIMESTAMP('%02d-%02d-%02d 00:00:00') )" % (y1, m1, d1, y2, m2, d2)