11th October 2018: PostgreSQL 11 RC 1 Released!
Unsupported versions: 7.0

Time Interval Operators

The time interval data type tinterval is a legacy from the original date/time types and is not as well supported as the more modern types. There are several operators for this type.

Table 4-5. Postgres Time Interval Operators

Operator Description Usage
#< Interval less than?  
#<= Interval less than or equal to?  
#<> Interval not equal?  
#= Interval equal?  
#> Interval greater than?  
#>= Interval greater than or equal to?  
<#> Convert to time interval  
<< Interval less than?  
| Start of interval  
~= Same as  
<?> Time inside interval?