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

OperatorDescriptionUsage
#< 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?