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