information_schema.attributes.interval_type

mysql

mariadb

tidb

postgres

type: CHARACTER_DATA NULL
Note:
If data_type identifies an interval type, this column contains the specification which fields the intervals include for this attribute, e.g., YEAR TO MONTH, DAY TO SECOND, etc. If no field restrictions were specified (that is, the interval accepts all fields), and for all other data types, this field is null.
© 1996-2022 The PostgreSQL Global Development Group
10-15
type: CHARACTER_DATA
Note:
If data_type identifies an interval type, this column contains the specification which fields the intervals include for this attribute, e.g., YEAR TO MONTH, DAY TO SECOND, etc. If no field restrictions were specified (that is, the interval accepts all fields), and for all other data types, this field is null.
© 1996-2022 The PostgreSQL Global Development Group
9.2-9.6
Note:
Not yet implemented
© 1996-2022 The PostgreSQL Global Development Group
8.2-9.1

cockroachdb

mssql