Time Functions ===================== **extract(unit from date)** returns one or more separate parts of a date or time in the specified unit. For example, this function can return the year, month, day, hour, or minute of a date or time. **time ± intervals** Adds an interval value of type unit to time type. Subtraction can be performed by using a negative value.