information_schema.columns.datetime_precision

Note:

Fractional-seconds precision, or NULL if not a time data type.

Note:

For time-type columns, the fractional seconds 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 column, 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 column, 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, or interval type, the declared precision; null for all other data types or if no precision was declared.

Note:

The precision level of columns with data type TIME/TIMETZ, TIMESTAMP/TIMESTAMPTZ, or INTERVAL. For all other data types, this column is NULL.

Note:

New in v20.2: The precision level of columns with data type TIME/TIMETZ, TIMESTAMP/TIMESTAMPTZ, or INTERVAL. For all other data types, this column is NULL.

Note:

Always NULL (unsupported by CockroachDB).

Note:

Subtype code for datetime and ISO interval data types. For other data types, NULL is returned.