For bigdatetime and bigtime the value displays reflects a microsecond value. bigdatetime and bigtime have default display formats that accomodate their increased precision.
hh:mm:ss.zzzzzzAM or PM
hh:mm:ss.zzzzzz
mon dd yyyy hh:mm:ss.zzzzzzAM(PM)
mon dd yyyy hh:mm:ss.zzzzzz
yyyy-mm-dd hh:mm:ss.zzzzzz
hours[:minutes[:seconds[.microseconds]] [AM | PM]
hours[:minutes[:seconds[number of milliseconds]] [AM | PM]
The seconds specification can include either a decimal portion preceded by a point or a number of milliseconds preceded by a colon. For example, “12:30:20:1” means twenty seconds and one millisecond past 12:30; “12:30:20.1” means twenty and one-tenth of a second past.
To store a bigdatetime or bigtime time value that includes microseconds, specify a string literal using a point. “00:00:00.1” means one tenth of a second past midnight and “00:00:00.000001” means one millionth of a second past midnight. Any value after the colon specifying fractional seconds continues to refer to a number of milliseconds. Such as “00:00:00:5” means 5 milliseconds.