information_schema.columns.interval_precision

mysql

mariadb

tidb

postgres

type: CARDINAL_NUMBER NULL
Note:
Applies to a feature not available in PostgreSQL (see datetime_precision for the fractional seconds precision of interval type columns)
© 1996-2022 The PostgreSQL Global Development Group
10-15
type: CARDINAL_NUMBER
Note:
Applies to a feature not available in PostgreSQL (see datetime_precision for the fractional seconds precision of interval type columns)
© 1996-2022 The PostgreSQL Global Development Group
9.2-9.6
type: CHARACTER_DATA
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 declared or implicit precision (i.e., number of significant digits); otherwise NULL.
© 2022 CockroachDB
20.1-21.2

mssql