[Bug]: Default Precision of Time

[zengyan1]

Is there an existing issue for the same bug?

• [X] I have checked the existing issues.

Branch Name

main

Commit ID

194fbf7

Other Environment Information

- Hardware parameters:
- OS type:
- Others:

Actual Behavior

When we use the data type 'time', we can write like 'time(precision)'. 'precision' is an integer, which means the number of fractional digits in the 'second' field of the time. If there is no 'precision', it will be a default value.

mysql: The default value is 0. The max value is 6.

PostgreSQL: The default value is 6. The max value is 6. In any case, all suffix zero in fractional digits will be truncated.

Snowflake: The default value is 9. The max value is 9.

Mo: The default value is 6. The max value is 6.

Expected Behavior

No response

Steps to Reproduce

create table t(a time,b time(2));
insert into t values('00:00:00','00:00:00');
insert into t values('00:00:00.0001','00:00:00.0001');
select * from t;

Additional information

No response