Both data types must be from the same INTERVAL family: either Year-Month or Day-Time. Types cannot be mixed.
| This INTERVAL data type … | Belongs to this INTERVAL family … |
|---|---|
|
Year-Month |
|
Day-Time |
Conversion of INTERVAL types is performed only when the fields and precisions are different.