- DATE - occupies 3 bytes . Has accuracy of 1 day . Data stored in 'YYYY-MM-DD' format
- TIME - occupies 3 to 5 bytes . Has accuracy of 100 nanoseconds. Data stored in 'hh:mm:ss.nnnnnnn' format.
- DATETIME2 - occupies 6 to 8 bytes . Has accuracy of 100 nanoseconds. Data stored in 'YYYY-MM-DD hh:mm:ss.nnnnnnn' format.
- DATETIMEOFFSET - occupies 8 to 10 bytes . Has accuracy of 100 nanoseconds. Data stored in 'YYYY-MM-DD hh:mm:ss.nnnnnnn [+|-]hh:mm' format. The DATETIMEOFFSET data type is similar to DATETIME2 but has time zone component extra.
State some new data types in SQL Server 2008 ?
New Data types in SQL Server 2008 are :
Subscribe to:
Post Comments (Atom)
Popular Posts
-
Cache Callback provides an ability where by some actions can be performed when that item is removed from cache CacheItemRemovedCallback ex...
-
XML DOM loads the entire xml document into memory whereas Simple API for XML ( SAX ) does not load entire xml document into memory XML DOM ...
-
Different types of diagrams in UML : UseCase diagram Class diagram Object diagram State diagram Sequence diagram Collaboration diagram...
-
Virtual-Override and New Class Child inherits from Class Parent and has mehtod ShowVirtualOverride() and ShowNew() methods. Please see th...
-
Question : Name few C# 3.0 enhancements ? Answer : The C# 3.0 language enhancements are as follows: Implicitly typed local variables I...
-
If locaction attribute is specified, must be one of: Any, Client, Downstream, None, Server or ServerAndClient.
Posts
No comments:
Post a Comment