I have an application that has several datetime field but the level of precision stops at the seconds level. These columns are assigned a default value of GETDATE() which returns a value down to the millisecond but that is NOT the case for the actual columns in a table.

Is there some type of globabl setting that defines the level of precision stored for a datetime column in a table?