2

I am using this code to generate a range of hourly datetime's:

from datetime import datetime, timedelta

def daterange(start_date, end_date):
    # timedelta only has days and seconds attributes
    for n in range(int ((end_date - start_date).seconds/3600 + 1)):
        yield start_date + timedelta(n)

start_date = datetime(2013, 1, 1, 14, 00)
end_date = datetime(2015, 6, 2, 5, 00)
for single_date in daterange(start_date, end_date):
    print single_date.strftime("%Y-%m-%d %H:%M")

But I am getting an unexpected result:

2013-01-01 14:00
2013-01-02 14:00
2013-01-03 14:00
2013-01-04 14:00
2013-01-05 14:00
2013-01-06 14:00
2013-01-07 14:00
2013-01-08 14:00
2013-01-09 14:00
2013-01-10 14:00
2013-01-11 14:00
2013-01-12 14:00
2013-01-13 14:00
2013-01-14 14:00
2013-01-15 14:00
2013-01-16 14:00

How can I better specify an hourly interval with the timedelta seconds attribute? I'd rather not use external packages like NumPy.

smci
  • 32,567
  • 20
  • 113
  • 146
interwebjill
  • 920
  • 13
  • 38

1 Answers1

15

You can build the timedelta directly and then add like:

Code:

def daterange(start_date, end_date):
    delta = timedelta(hours=1)
    while start_date < end_date:
        yield start_date
        start_date += delta

Test Code:

from datetime import datetime, timedelta

start_date = datetime(2013, 1, 1, 14, 00)
end_date = datetime(2015, 6, 2, 5, 00)
for single_date in daterange(start_date, end_date):
    print(single_date.strftime("%Y-%m-%d %H:%M"))

Results:

2013-01-01 14:00
2013-01-01 15:00
2013-01-01 16:00
2013-01-01 17:00
2013-01-01 18:00
2013-01-01 19:00
2013-01-01 20:00
2013-01-01 21:00
2013-01-01 22:00
2013-01-01 23:00
2013-01-02 00:00
2013-01-02 01:00
Stephen Rauch
  • 47,830
  • 31
  • 106
  • 135