Export (0) Print Expand All Expand Minimize 19 out of 46 rated
this helpful - Rate this topic  datetime (Transact-SQL)  Defines
a date that is combined with a time of day with fractional
seconds that is based on a 24-hour clock.   Use the time, date,
datetime2 and datetimeoffset data types for new work. These
types align with the SQL Standard. They are more portable. time,
datetime2 and datetimeoffset provide more seconds precision.
datetimeoffset provides time zone support for globally deployed
applications.  For an overview of all Transact-SQL date and time
data types and functions, see Date and Time Data Types and
Functions (Transact-SQL). For information and examples that are
common to date and time data types and functions, see Using Date
and Time Data.       DECLARE @MyDatetime datetime  CREATE TABLE
Table1 ( Column1 datetime )  Default string literal formats
(used for down-level client)  Not applicable  Date range
January 1, 1753, through December 31, 9999  Time range  00:00:00
through 23:59:59.997