datetime.datetime and mysql different after python2.3

Thomas Rachel nutznetz-0c1b6768-bfa9-48d5-a470-7603bd3aa915 at spamschutz.glglgl.de
Fri Jun 3 05:05:58 EDT 2011


Am 01.06.2011 20:42 schrieb Tobiah:
> I'm grabbing two fields from a MySQLdb connection.
> One is a date type, and one is a time type.
>
> So I put the values in two variables and print them:
>
> import datetime
> date, time = get_fields() # for example
> print str(type(date)), str((type(time)))
> print str(date + time)
>
> In python 2.3.4, I get:
>
> <type 'DateTime'>  <type 'DateTimeDelta'>
> 2010-07-06 09:20:45.00
>
> Put in python2.4 and greater, I get this:
>
> <type 'datetime.date'>  <type 'datetime.timedelta'>
> 2010-07-06
>
> So I'm having trouble adding the two to get one
> datetime.

Here you can do the following:

import datetime
date, time = get_fields() # for example
print str(type(date)), str((type(time)))
dt = datetime.datetime(*date.timetuple()) + time
print dt

(BTW: print calls str() in an case, so it is not needed to put it 
explicitly here...)


Thomas



More information about the Python-list mailing list