COMPUTER APPLICATIONS
DATABASE MANAGEMENT SYSTEMS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
A data types which stores data and time values from the year 100 through 9999.
|
|
Currency
|
|
|
Date/Time
|
|
|
OLE Objects
|
|
|
Yes/No
|
Explanation:
Detailed explanation-1: -A calendar date is stored internally as an integer value equal to the number of days since December 31, 1899. Because DATE values are stored as integers, you can use them in arithmetic expressions.
Detailed explanation-2: -SQL Server comes with the following data types for storing a date or a date/time value in the database: DATE-format YYYY-MM-DD. DATETIME-format: YYYY-MM-DD HH:MI:SS. SMALLDATETIME-format: YYYY-MM-DD HH:MI:SS.
There is 1 question to complete.