First, you can convert it to a datetime.datetime object like this: >>> import datetime >>> fmt=”%Y.%m.%d” >>> s=”2012.11.07″ >>> dt = datetime.datetime.strptime(s, fmt) >>> dt datetime.datetime(2012, 11, 7, 0, 0) Then you can use the methods on datetime to get what you want… except that datetime doesn’t have the function you want directly, so you … Read more
OADate is similar to Julian Dates, but uses a different starting point (December 30, 1899 vs. January 1, 4713 BC), and a different ‘new day’ point. Julian Dates consider noon to be the beginning of a new day, OADates use the modern definition, midnight. The Julian Date of midnight, December 30, 1899 is 2415018.5. This … Read more
I have a suspicion. Only a suspicion, but a pretty strong one. That value represents October 19th 2064. The Brazilian time zones observe daylight saving time starting at local midnight – that’s when their clocks go forward, so midnight itself doesn’t exist. October 19th is one of those transitions. Here’s some sample code using Noda … Read more
datetime.datetime(year, 1, 1) + datetime.timedelta(days – 1)