Create table TestTime(a time(6)) 

prepst#!# Insert into TestTime Values(@a) #!#Time|-|a|-|12:45:37.123|-|0
prepst#!#exec#!#Time|-|a|-|12:45:37.123|-|3
prepst#!#exec#!#Time|-|a|-|12:45:37.12|-|2
prepst#!#exec#!#Time|-|a|-|12:45:37.1|-|1
prepst#!#exec#!#Time|-|a|-|12:45:37.1234|-|4
prepst#!#exec#!#Time|-|a|-|12:45:37.123456|-|6
prepst#!#exec#!#Time|-|a|-|12:45:37.123456|-|5
prepst#!#exec#!#Time|-|a|-|<NULL>

select * from TestTime

Drop table TestTime

Create table TestTime(a time(5)) 

prepst#!# Insert into TestTime Values(@a) #!#Time|-|a|-|12:45:37.123|-|0
prepst#!#exec#!#Time|-|a|-|12:45:37.123|-|3
prepst#!#exec#!#Time|-|a|-|12:45:37.12|-|2
prepst#!#exec#!#Time|-|a|-|12:45:37.1|-|1
prepst#!#exec#!#Time|-|a|-|12:45:37.1234|-|4
prepst#!#exec#!#Time|-|a|-|12:45:37.123456|-|6
prepst#!#exec#!#Time|-|a|-|12:45:37.123456|-|5
prepst#!#exec#!#Time|-|a|-|<NULL>

select * from TestTime

Drop table TestTime

Create table TestTime(a time(4)) 

prepst#!# Insert into TestTime Values(@a) #!#Time|-|a|-|12:45:37.123|-|0
prepst#!#exec#!#Time|-|a|-|12:45:37.123|-|3
prepst#!#exec#!#Time|-|a|-|12:45:37.12|-|2
prepst#!#exec#!#Time|-|a|-|12:45:37.1|-|1
prepst#!#exec#!#Time|-|a|-|12:45:37.1234|-|4
prepst#!#exec#!#Time|-|a|-|12:45:37.123456|-|6
prepst#!#exec#!#Time|-|a|-|12:45:37.123456|-|5
prepst#!#exec#!#Time|-|a|-|<NULL>

select * from TestTime

Drop table TestTime

Create table TestTime(a time(3)) 

prepst#!# Insert into TestTime Values(@a) #!#Time|-|a|-|12:45:37.123|-|0
prepst#!#exec#!#Time|-|a|-|12:45:37.123|-|3
prepst#!#exec#!#Time|-|a|-|12:45:37.12|-|2
prepst#!#exec#!#Time|-|a|-|12:45:37.1|-|1
prepst#!#exec#!#Time|-|a|-|12:45:37.1234|-|4
prepst#!#exec#!#Time|-|a|-|12:45:37.123456|-|6
prepst#!#exec#!#Time|-|a|-|12:45:37.123456|-|5
prepst#!#exec#!#Time|-|a|-|<NULL>

select * from TestTime

Drop table TestTime

Create table TestTime(a time(2)) 

prepst#!# Insert into TestTime Values(@a) #!#Time|-|a|-|12:45:37.123|-|0
prepst#!#exec#!#Time|-|a|-|12:45:37.123|-|3
prepst#!#exec#!#Time|-|a|-|12:45:37.12|-|2
prepst#!#exec#!#Time|-|a|-|12:45:37.1|-|1
prepst#!#exec#!#Time|-|a|-|12:45:37.1234|-|4
prepst#!#exec#!#Time|-|a|-|12:45:37.123456|-|6
prepst#!#exec#!#Time|-|a|-|12:45:37.123456|-|5
prepst#!#exec#!#Time|-|a|-|<NULL>

select * from TestTime

Drop table TestTime

Create table TestTime(a time(1)) 

prepst#!# Insert into TestTime Values(@a) #!#Time|-|a|-|12:45:37.123|-|0
prepst#!#exec#!#Time|-|a|-|12:45:37.123|-|3
prepst#!#exec#!#Time|-|a|-|12:45:37.12|-|2
prepst#!#exec#!#Time|-|a|-|12:45:37.1|-|1
prepst#!#exec#!#Time|-|a|-|12:45:37.1234|-|4
prepst#!#exec#!#Time|-|a|-|12:45:37.123456|-|6
prepst#!#exec#!#Time|-|a|-|12:45:37.123456|-|5
prepst#!#exec#!#Time|-|a|-|<NULL>

select * from TestTime

Drop table TestTime

Create table TestTime(a time(0)) 

prepst#!# Insert into TestTime Values(@a) #!#Time|-|a|-|12:45:37.123|-|0
prepst#!#exec#!#Time|-|a|-|12:45:37.123|-|3
prepst#!#exec#!#Time|-|a|-|12:45:37.12|-|2
prepst#!#exec#!#Time|-|a|-|12:45:37.1|-|1
prepst#!#exec#!#Time|-|a|-|12:45:37.1234|-|4
prepst#!#exec#!#Time|-|a|-|12:45:37.123456|-|6
prepst#!#exec#!#Time|-|a|-|12:45:37.123456|-|5
prepst#!#exec#!#Time|-|a|-|<NULL>

select * from TestTime

Drop table TestTime