- 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
-
RegisterStartUpScript This adds the javascript code at the end of the page before the closing of form tag. RegisterClientScriptBlock Th...
-
delegate string Delegate1(object o); delegate object Delegate2(string s); static string Dispaly(object o) { r...
-
@@ERROR is a global variable used to return error number of last T-SQL.
-
Please follow below steps to enable transaction in Web Service : 1.Add a reference to System.EnterpriseServices.dll. 2.Add the System.Ente...
-
Authentication is process of obtaining credentials such as username and password and validating the credentials. There are 3 types of ASP....
-
window.open
-
To be in second normal form i.e 2NF , all information attributes or fields of the table are attributes of entity of table schema. All inform...
-
Replication is the way to keep data synchronised in multiple datbases. SQL Replication consists of two important part : Publisher - Datab...
-
The WebMethod attribute in Web Service provides the following properties: BufferResponse CacheDuration Description EnableSession Messa...
-
Computed Column is virtual column in table whose value is computed at runtime.The values are not stored in table but computed by the express...
Posts
No comments:
Post a Comment