This page in other versions: Unsupported versions: 6.4

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 9-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?  

Submit correction

If you see anything in the documentation that is not correct, does not match your experience with the particular feature or requires further clarification, please use this form to report a documentation issue.

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group