`information_schema.routines.datetime_precision`

mysql

type: BIGINT NULL

5.7-8

type: NULL

Note:

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

5.1-10.8

type: CARDINAL_NUMBER NULL

Note:

Always null, since this information is not applied to return data types in PostgreSQL

10-15

type: CARDINAL_NUMBER

Note:

Always null, since this information is not applied to return data types in PostgreSQL

7.4-9.6

type: NULL

Note:

Always NULL.

type: SMALLINT NULL

Note:

Fractional precision of a second if the return value is of type datetime. Otherwise, returns NULL.