Fredrik Lundh wrote:
> "Kun" wrote:
>
>> because in my sql database, the date is only 'date' (as in yyyy-mm-dd),
>> only when i extract it with my python-cgi does the date turn into
>> (yyyy-mm-dd 00:00:00.00), thus i figured the best way to fix this
>> problem is to parse it after the matter.
>
> you still make no sense. why not fix this in your python cgi script ?
>
> </F>
>
>
>
i have the following python-cgi which extracts data from a mysql table,
how do i parse the date so that it doesn't display the time '00:00:00.00'?
print '<h1>Query Results</h1>'
try:
db = MySQLdb.connect(host="localhost", user="xxx", passwd="xxxx",
db="xxxx")
cursor = db.cursor()
sqlstring = (select + " FROM dir" + where + order_by + limit)
print sqlstring
cursor.execute(sqlstring)
numrows = cursor.rowcount
numcols = len(cursor.description)
#print sqlstring
#print "SQL statement used:<br>" + sqlstring
print """<table border="1" cellpadding="1" cellspacing="1">"""
print "<tr>"
for col in range(0, numcols):
print "<td><b>", cursor.description[col][0], "</b></td>"
print "</tr>"
for row in range(0,numrows):
record = cursor.fetchone()
print "<tr>"
for col in range(0, numcols):
print "<td>", record[col], "</td>"
print "</tr>"
except MySQLdb.OperationalError, message:
print "Error %d:<br>%s<br><br>" % (message[0], message[1])
print "SQL statement used:<br>" + sqlstring
print "</table>"
--
http://mail.python.org/mailman/listinfo/python-list
