18. Working with Data Types and Data Display Formats : Data Types : Date Data Type : Relative Times and Dates
Share this page                  
Relative Times and Dates
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:
5 years 8 months 14 days
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.