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.
|
|
