information_schema.columns.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 column, 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 column, 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
7.4-9.1

cockroachdb

type: unknown
Note:
If data_type is INTERVAL, the specified fields (e.g., YEAR TO MONTH); otherwise NULL.
© 2022 CockroachDB
20.1-21.2

mssql