A static time span is the definition of a time span based on a lower boundary timestamp and an upper boundary timestamp. Additionally a static time span defines separately for the lower and the upper time span if the boundary timestamps are part of the interval or not (c.f. closed interval, open interval, half-open interval) See table 1 for effects of boundary inclusion.
The lower and upper value of a static time span can be empty to define an 'infinite' lower or upper boundary. See Table 2 for effects of empty boundaries.
Lower boundary |
Upper boundary |
Effective time span |
yes |
yes |
2011-01-01 00:00:00.0000000 to |
yes |
no |
2011-01-01 00:00:00.0000000 to |
no |
yes |
2011-01-01 00:00:00.0000001 to |
no |
no |
2011-01-01 00:00:00.0000001 to |
Table 1: Effect of inclusion or non-inclusion of interval boundaries for example lower boundary = 2011-01-01 00:00:00.0000000, upper boundary = 2012-01-01 00:00:00.0000000
Lower boundary |
Upper boundary |
Effective time span |
2011-01-01 00:00:00.0000000 |
2012-01-01 00:00:00.0000000 |
2011-01-01 00:00:00.0000000 to 2012-01-01 00:00:00.0000000 |
2011-01-01 00:00:00.0000000 |
empty |
2011-01-01 00:00:00.0000000 to 9999-12-31 23:59:59.9999999 |
empty |
2012-01-01 00:00:00.0000000 |
0001-01-01 00:00:00.0000000 to 2012-01-01 00:00:00.0000000 |
empty |
empty |
0001-01-01 00:00:00.0000000 to 9999-12-31 23:59:59.9999999 |
Table 2: Effect of empty boundaries in a static time span definition
