Datetime's always stored with accuracy of one three-hundredth of a second rounded to increments of .000, .003, or .007 seconds. In EM datetime values are shown w/o milliseconds or even w/o time part ii it's 00:00:00.000. The following selects will return actual values stored in datetime field, including milliseconds.
SELECT CONVERT( VARCHAR(32), fld_dt, 121) FROM mytable
SELECT fld_dt FROM mytable
>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?
--sb--