Temporal values include dates, times, and date/time values that have both a date and time. More specialized temporal types are timestamp (commonly used for recording “current date and time”) and year (for temporal values that require a resolution only to year units). Direct use of temporal values in expressions occurs primarily in comparison operations, or in arithmetic operations that add an interval to or subtract an interval from a temporal value. Otherwise, most temporal value operations are performed by using functions. Temporal data may be generated via any of the following means: Copying data from an existing date, datetime, or time column Executing a built-in function that returns a date, datetime, or time column Building a string representation of the temporal data to be evaluated by the server Date Components: Type Default Format DATE ...
“The best way to be ready for the future is to invent it.”— John Sculley