information_schema.attributes.datetime_precision

mysql

mariadb

tidb

postgres

type: CARDINAL_NUMBER NULL
Note:
If data_type identifies a date, time, timestamp, or interval type, this column contains the (declared or implicit) fractional seconds precision of the type for this attribute, that is, the number of decimal digits maintained following the decimal point in the seconds value. For all other data types, this column is null.
© 1996-2022 The PostgreSQL Global Development Group
10-15
type: CARDINAL_NUMBER
Note:
If data_type identifies a date, time, timestamp, or interval type, this column contains the (declared or implicit) fractional seconds precision of the type for this attribute, that is, the number of decimal digits maintained following the decimal point in the seconds value. For all other data types, this column is null.
© 1996-2022 The PostgreSQL Global Development Group
8.4-9.6
Note:
If data_type identifies a date, time, or interval type, the declared precision; null for all other data types or if no precision was declared.
© 1996-2022 The PostgreSQL Global Development Group
8.2-8.3

cockroachdb

mssql