datetime.datetime and mysql different after python2.3

[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.

Thanks for any insight.

Tobiah

 

[Tobiah]

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

News reader stripped newlines

 

[Thomas Rachel]

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