Hi All:

Why does the time field always default to Time(7) in MSSQL 2008? What is
the best format to use for external 3rd party tools?

Can you provide more details of where you are looking and see this?
Datetimes are stored internally as 2 4 byte integers. How they are displayed
is up to the tool you use to view it. SQL Server does not store any
formatting at all for display purposes. If you are using SSMS for instance
it will go off the default or current settings for windows.

--

Andrew J. Kelly SQL MVP
Solid Quality Mentors

"Larry Law" <larry-law (AT) live (DOT) com> wrote