Search notes:

SQL Server: datatype datetime

datetime stores a date and time with accuracy of a thousandst of a second with the last decimal being 0, 3 or 7.

See also

datetime2
The Oracle equivalent datatype date which stores the a date time as accurate as seconds.
data types and date and/or time related data types

Index