InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 12:37:49 GMT20http://www.sqlservercentral.com/Forums/Topic579471-1222-1.aspxNice question...Fri, 03 Oct 2008 01:59:01 GMTAnipaulhttp://www.sqlservercentral.com/Forums/Topic579471-1222-1.aspxGood question. A lot of people will like the separate date and time. :w00t:Thu, 02 Oct 2008 11:30:59 GMTOCTomhttp://www.sqlservercentral.com/Forums/Topic579471-1222-1.aspxTo save y'all the trouble of clicking each MSDN link given in the solution, here are my condensations of the basic definitions....[b]date[/b]Defines a date. Three bytes with a range of 0001-01-01 through 9999-12-31.[b]time[/b]Defines a time of day. Optionally specify a precision for the fractions of a second. Three to five bytes depending on precision (0-7 digits for fraction of second).[b]datetime2[/b]Defines a date that is combined with a time of day that is based on 24-hour clock. datetime2 can be considered as an extension of the existing datetime type that has a larger date range (0001-01-01 through 9999-12-31), a larger default fractional precision, and optional user-specified precision (0-7 digits for fraction of second). Six to eight bytes depending on precision.[b]datetimeoffset[/b]Defines a date that is combined with a time of a day that has time zone awareness and is based on a 24-hour clock. Similar to [b]datetime2[/b] with the addition of storing the offset from UTC from -14:00 to +14:00. Ten bytes.And, for comparison...[b]datetime[/b]Defines a date that is combined with a time of day with fractional seconds that is based on a 24-hour clock. Date range is January 1, 1753, through December 31, 9999. Time range is 00:00:00 through 23:59:59.997 rounded to increments of .000, .003, or .007 seconds. Eight bytes. Thu, 02 Oct 2008 07:56:10 GMTjohn.arnotthttp://www.sqlservercentral.com/Forums/Topic579471-1222-1.aspxWhat is the DateTime2 and DateTimeOffset?Thu, 02 Oct 2008 07:00:12 GMTJoe Pattisonhttp://www.sqlservercentral.com/Forums/Topic579471-1222-1.aspxComments posted to this topic are about the item [B]<A HREF="/questions/Data+Types/64334/">New data types in SQL 2008</A>[/B]Wed, 01 Oct 2008 21:43:18 GMTbitbucket-25253