need to consolidate date ranges, each data range has a confirmed date, for example dates aexample 1: range [a,d) with X and [b,c) with Y will become [a,b) with X, [b,c) with Y, [c,d) with X
another example: [a,c) with X and [b,d) with Y will become [a,b) with X and [b,d) with Y
how to consolidate the lists of date ranges ? Thanks.
need to consolidate date ranges, each data range has a confirmed date, for
example
dates aexample 1:
range [a,d) with X and [b,c) with Y will become [a,b) with X, [b,c) with Y, [c,d) with X
another example:
[a,c) with X and [b,d) with Y will become [a,b) with X and [b,d) with Y
how to consolidate the lists of date ranges ? Thanks.
你这是个SQL/编程题,本版大牛可能不屑出手,移到军版去说不定有人会上。
【 在 starbase (四海为家) 的大作中提到: 】
: need to consolidate date ranges, each data range has a confirmed date, for
: example
: dates a