Python date

[borthouth]

Hi,

I am using zope with an SQL database in the background. I have a date stored in the database as "2007/08/20 09:27:16.593 GMT+1".

Is there anyway in python to add an int of "60" to the date?

[bartonc]

To add "60" days to a string date takes some machinations:

>>> import time
>>> import datetime as dt
>>> theDate, theTime, theZone = "2007/08/20 09:27:16.593 GMT+1".split()
>>> timeObj = time.strptime(" ".join([theDate, theTime.split('.')[0]]), "%Y/%m/%d %H:%M:%S")
>>> toAdd = dt.timedelta(days = 60)
>>> timeObj
(2007, 8, 20, 9, 27, 16, 0, 232, -1)
>>> dtObj = dt.datetime(*timeObj[:6])
>>> dtObj
datetime.datetime(2007, 8, 20, 9, 27, 16)
>>> dtObj + toAdd
datetime.datetime(2007, 10, 19, 9, 27, 16)
>>> 

[bartonc]

Of course, if your DB is MySQL you could call ADDDATE():

SELECT ADDTIME('1997-12-31 23:59:59.999999', '1 1:1:1.000002');

-> '1998-01-02 01:01:01.000001'

[bartonc]

Hi,

I am using zope with an SQL database in the background. I have a date stored in the database as "2007/08/20 09:27:16.593 GMT+1".

Is there anyway in python to add an int of "60" to the date?

Here's a slightly more complete example:

import time
import datetime as dt
theDate, theTime, theZone = "2007/08/20 09:27:16.593 GMT+1".split()
noDec = theTime.split('.')[0]
timeObj = time.strptime(" ".join([theDate, noDec]), "%Y/%m/%d %H:%M:%S")
print timeObj
toAdd = dt.timedelta(days = 60)
dtObj = dt.datetime(*timeObj[:6])
print repr(dtObj)
strToInsert = " ".join([str(dtObj + toAdd), theZone])
print strToInsert
 
# output
(2007, 8, 20, 9, 27, 16, 0, 232, -1)
datetime.datetime(2007, 8, 20, 9, 27, 16)
2007-10-19 09:27:16 GMT+1