Improving on Dale K’s answer, I suggest you use a tally table or function, as this is usually more performant. I have used Itzik Ben-Gan’s well-known one below: DECLARE @StartDate date=”2020-11-01″, @EndDate date=”2021-02-22″; WITH L0 AS ( SELECT 1 AS c FROM (VALUES(1),(1),(1),(1),(1),(1),(1),(1), (1),(1),(1),(1),(1),(1),(1),(1)) AS D(c) ), L1 AS ( SELECT 1 AS c FROM … Read more
The currently accepted answer does not answer the question. And it is wrong in principle. a BETWEEN x AND y translates to: a >= x AND a <= y Including the upper bound, while people typically need to exclude it: a >= x AND a < y With dates you can easily adjust. For the … Read more
Determine the latest of the two start dates and the earliest of the two end dates. Compute the timedelta by subtracting them. If the delta is positive, that is the number of days of overlap. Here is an example calculation: >>> from datetime import datetime >>> from collections import namedtuple >>> Range = namedtuple(‘Range’, [‘start’, … Read more
Nope, doing a simple comparison looks good to me: return dateToCheck >= startDate && dateToCheck < endDate; Things to think about though: DateTime is a somewhat odd type in terms of time zones. It could be UTC, it could be “local”, it could be ambiguous. Make sure you’re comparing apples with apples, as it were. … Read more
As you say, this is pretty easy in SQL, so why not do it in SQL? import pandas as pd import sqlite3 #We’ll use firelynx’s tables: presidents = pd.DataFrame({“name”: [“Bush”, “Obama”, “Trump”], “president_id”:[43, 44, 45]}) terms = pd.DataFrame({‘start_date’: pd.date_range(‘2001-01-20′, periods=5, freq=’48M’), ‘end_date’: pd.date_range(‘2005-01-21′, periods=5, freq=’48M’), ‘president_id’: [43, 43, 44, 44, 45]}) war_declarations = pd.DataFrame({“date”: [datetime(2001, … Read more
Converting them to timestamps is the way to go alright, using strtotime, e.g. $start_date=”2009-06-17″; $end_date=”2009-09-05″; $date_from_user=”2009-08-28″; check_in_range($start_date, $end_date, $date_from_user); function check_in_range($start_date, $end_date, $date_from_user) { // Convert to timestamp $start_ts = strtotime($start_date); $end_ts = strtotime($end_date); $user_ts = strtotime($date_from_user); // Check that user date is between start & end return (($user_ts >= $start_ts) && ($user_ts <= $end_ts)); … Read more
Date.prototype.addDays = function(days) { var date = new Date(this.valueOf()); date.setDate(date.getDate() + days); return date; } function getDates(startDate, stopDate) { var dateArray = new Array(); var currentDate = startDate; while (currentDate <= stopDate) { dateArray.push(new Date (currentDate)); currentDate = currentDate.addDays(1); } return dateArray; } Here is a functional demo http://jsfiddle.net/jfhartsock/cM3ZU/
Why are there two nested iterations? For me it produces the same list of data with only one iteration: for single_date in (start_date + timedelta(n) for n in range(day_count)): print … And no list gets stored, only one generator is iterated over. Also the “if” in the generator seems to be unnecessary. After all, a … Read more
You could also take a look at the DatePeriod class: $period = new DatePeriod( new DateTime(‘2010-10-01’), new DateInterval(‘P1D’), new DateTime(‘2010-10-05’) ); Which should get you an array with DateTime objects. To iterate foreach ($period as $key => $value) { //$value->format(‘Y-m-d’) }