The TIME type can represent a time of day, a duration, or an interval between two events (which can be much longer than 24 hours).
OceanBase Database allows you to assign values to a TIME column by using a string or a number.
The retrieval and display format of a TIME value is 'hh:mm:ss', with a range of '-838:59:59' to '838:59:59'.
The display format of a TIME value can also include the fractional part of the seconds, in the format 'hh:mm:ss[.fraction]'. The precision can be up to microseconds (6 digits), with a range of '-838:59:59.000000' to '838:59:59.000000'. The fractional part must be separated from the other time components by a decimal point. Other separators are not recognized.
The syntax of TIME is as follows:
TIME[(fsp)]
The optional fsp parameter specifies the precision of the fractional seconds, with a range of [0,6]. A value of 0 indicates no fractional part. If omitted, the default precision is 0.