Time Processing
ISO 8601 dates, durations, intervals, and temporal algebra
9 pages
Tutorial 1: Dates, Comparisons & Range Queries
Hands-on tutorial using the WOQL Playground to learn date representation, comparison predicates, half-open range filtering, and the as-of vs period query pattern.
Tutorial 2: Durations, Month Arithmetic & Sequences
Hands-on tutorial using the WOQL Playground to learn duration arithmetic, EOM preservation, sequence generation, weekday extraction, and month boundary predicates.
Tutorial 3: Intervals & Allen's Temporal Algebra
Hands-on tutorial using the WOQL Playground to learn interval construction, deconstruction, and Allen's 13 temporal relations for verifying how periods relate to each other.
Tutorial 4: Creative Temporal Patterns
Hands-on tutorial using the WOQL Playground to solve real business problems by exploiting WOQL's logic-programming nature — generators, matchers, unification, and composition of temporal predicates.
Allen's Interval Algebra and ISO 8601 Intervals
Guide to Allen's Interval Algebra in WOQL — covering the xdd:dateTimeInterval type, typecasting between inclusive and half-open intervals, all 13 Allen relations, interval classification, and converting between reporting durations and temporal intervals.
End-of-Month Preservation Rules
Complete reference for TerminusDB's end-of-month (EOM) preservation rules — the financial convention for month-based duration arithmetic that keeps month-end dates on month-end boundaries.
ISO 8601 Time Processing in TerminusDB
Learn to process dates, times, durations, and intervals accurately in TerminusDB. Four progressive tutorials cover everything from basic date comparison to creative temporal pattern-solving for financial reporting and scheduling.
WOQL ISO8601 Time and Date Handling
Complete guide to WOQL date, time, duration, and interval handling — ISO 8601 types, comparators, sequences, Allen's Interval Algebra, and financial EOM rules.
xdd:dateTimeInterval Semantics
Reference for xdd:dateTimeInterval storage semantics — how plain date endpoints are converted to fully qualified UTC datetimes and why.