stl_gtfs_service_day
Determine which GTFS service date(s) a given wall-clock instant falls under, returning the matching gtfs_time. Use when a departure time appears off by a day due to GTFS's noon-based time convention.
Instructions
Which GTFS service date(s) a wall-clock instant could belong to, with the corresponding gtfs_time for each.
Use this whenever a departure time looks off by a day. GTFS measures times from noon-minus-twelve-hours, not local midnight -- on DST transition days those differ by an hour.
Args: timestamp: ISO-8601 instant. Naive values read as America/Chicago.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| timestamp | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |