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.