In PostgreSQL, Time(p) is a Time type with a precision of
p, where precision is a positive number
Precision levels of 0-6 will have the Time stored as an Integer
Levels 7 and above will store the Time as a floating point.
Is (MS) SQL Server, the type would be the same Time(p), however; the range is limited from 0-7
PostgreSQL: Documentation: 9.1: Date/Time Types[
^]
time (Transact-SQL) - SQL Server | Microsoft Docs[
^]