Relative time and date intervals are also handled, which are units of time not fixed as absolutes. An example of a relative time interval is:

You can use the interval and date functions to carry out operations on dates in SQL or in the Interactive Terminal Monitor. The interval function calculates the difference between two dates. The date conversion function transforms strings into dates.