Description
Select transition occurrence records inside a half-open UTC window without sorting or deduplicating.
An offset maps a supplied UTC coordinate to local civil coordinates by local = UTC + offset. Half-open spans include their start and exclude their end. A forward offset jump can leave local coordinates uncovered; a backward jump can give several UTC interpretations of one local value. These tools use explicit synthetic civil-second observations rather than a named-zone database.
Select transition occurrence records inside a half-open UTC window without sorting or deduplicating.
When to use this tool
Use this tool to select transition occurrence records inside a half-open UTC window without sorting or deduplicating.
How to use the tool and how it works
- Enter transitionsJson, start, end using the definitions below. Serialize JSON text fields in the decoded shape shown below.
- Run the operation. Resolve input-format errors before interpreting an output.
- Read result.transitions, using the stated boundary, ordering, sign and absence conventions.
Select original transition occurrences satisfying start≤at<end and retain their indexes, without sorting or deduplication.1
| Input field | Meaning and units | Accepted input |
|---|---|---|
| transitionsJson | JSON array of {at,before,after} second-valued observations; at is UTC and before/after are signed offsets. | Text, at most 8,192 UTF-16 code units; narrower grammar/range rules also apply. |
| start | Inclusive UTC or local window start in seconds, as explicitly stated by this operation. | Finite numeric value satisfying the stated comparisons. |
| end | Exclusive window end in seconds, on the same coordinate scale as start. | Finite numeric value satisfying the stated comparisons. |
These decoded structures show the examples inside JSON text fields. Supply their serialized JSON strings as input.
{
"transitionsJson": [
{
"at": 10,
"before": 0,
"after": 2
},
{
"at": 20,
"before": 2,
"after": 0
}
]
}| Output field | Interpretation |
|---|---|
| result | Object containing the fields below. |
| result.transitions | Selected original transition records with source indexes. |
{
"input": {
"transitionsJson": "[{\"at\": 10, \"before\": 0, \"after\": 2}, {\"at\": 20, \"before\": 2, \"after\": 0}]",
"start": 10,
"end": 20
},
"output": {
"result": {
"transitions": [
{
"at": 10,
"before": 0,
"after": 2,
"index": 0
}
]
}
}
}Limitations and assumptions
- Malformed record fields cause an error; chronology and before/after continuity are not required by this selector.
- Span/transition coordinates are finite seconds within ±10¹² and offsets within ±86,400 seconds. Spans require start<end. No IANA database, calendar parsing, daylight-saving inference or leap seconds are included.
- Every declared outer field is required and unknown outer fields are rejected. Strings and JSON text have size limits, lists are bounded to 128 entries, and JSON nesting/node counts are bounded. Tighter operation-specific bounds stated above take precedence.
- Ordinary numeric outputs must be finite and within safe-integer magnitude. Exact large lengths/counts use decimal strings. Original record indexes and code-unit positions are zero-based; span ends are exclusive unless stated otherwise.
Alternative or Complementary methods
Keep all timestamps on one origin and in seconds, and retain gaps or competing observations. Use a maintained time-zone library when real dates, named zones or historical rules are required.
References
Similar or alternative tools
- Time Zone Local Candidate Policy Selector
Choose earliest/latest UTC candidate or unique-only under an explicit policy; empty or unresolved evidence returns null.
- Time Zone Local Window UTC Span List
Invert a local half-open window against every observed offset span, preserving multiple UTC solutions and source span indexes.