s******e 发帖数: 96 | 1 need to consolidate date ranges, each data range has a confirmed date, for
example
dates a
example 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. | T********2 发帖数: 1 | 2 你这是个SQL/编程题,本版大牛可能不屑出手,移到军版去说不定有人会上。
【在 s******e 的大作中提到】 : need to consolidate date ranges, each data range has a confirmed date, for : example : dates a: example 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.
|
|