date_convert.py

from time import strptime, strftime

d = "2013-08-12"

oldFormat = "%Y-%m-%d"
newFormat = "%d-%b-%Y"
oldDate = strptime(d, oldFormat)

# print oldDate
# print strftime(newFormat, oldDate).upper()

infile = open('tobeconvert.csv', 'r')
outfile = open('new.csv', 'w')
for line in infile:
	first = line.split(',')[0]
	second = line.split(',')[1]
	firstTimeTuple = strptime(first, oldFormat)
	new_first = strftime(newFormat, firstTimeTuple).upper()
	if second != "\n":
		secondTimeTuple = strptime(second[:10], oldFormat)
		new_second = strftime(newFormat, secondTimeTuple).upper() + '\n'
	else:
		new_second = "\n"
	newline = new_first + ',' + new_second
	outfile.write(str(newline))

outfile.close()