information_schema.domains.datetime_precision

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 domain, 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.

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 domain, 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.

Note:

If the domain has a date, time, or interval type, the declared precision; null for all other data types or if no precision was declared.

Note:

Subtype code for datetime and ISO interval data type. For other data types, this column returns a NULL.