Never mind guys I already solved it... Just for the record here's what I came up with
def get_announcement(con):
try:
c = con.cursor(DictCursor)
query = """
SELECT
id,
page_id,
title,
contents,
bnr_img,
DATE_FORMAT(start_date, %s),
DATE_FORMAT(end_date, %s)
FROM announcement
ORDER BY id DESC;
"""
format= "'%M %D, %Y'"
c.execute(query,[format,format])
dbres = c.fetchall()
if not dbres: return None
return dbres
finally:
if c: c.close()