Management of Temporal Data

The main purpose of this website is to present SQL code.
For theoretical background refer to:
“Managing Time in Relational Databases” by Tom Johnston & Randall Weis
or Wikipedia:


From Point in Time to Time Interval

To warm up – unitemporal:  Unitemporal Data
Main point – bitemporal: Generate Bitemporal Intervals



Legal Disclosure

The translations into English with help of