BUSINESS ADMINISTRATION
BUSINESS POLICY
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Date
|
|
|
TimeOfDate
|
|
|
DateTime
|
|
|
TimeDate
|
Detailed explanation-1: -The TIMESTAMP data type is used for values that contain both date and time parts. TIMESTAMP has a range of ‘1970-01-01 00:00:01’ UTC to ‘2038-01-19 03:14:07’ UTC.
Detailed explanation-2: -The DATETIME data type stores an instant in time expressed as a calendar date and time of day. You select how precisely a DATETIME value is stored; its precision can range from a year to a fraction of a second.
Detailed explanation-3: -The DATE datatype stores date and time information. Although date and time information can be represented in both character and number datatypes, the DATE datatype has special associated properties. For each DATE value, Oracle stores the following information: century, year, month, date, hour, minute, and second.
Detailed explanation-4: -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.
Detailed explanation-5: -The TIMESTAMP data type consists of date and time information. Its default format, YYYY-MM-DD HH24:MI:SS <n>, represents the fractional seconds, where <n> indicates the number of digits in fractional part. The range of the time stamp value is between 0001-01-01 00:00:00.0000000 and 9999-12-31 23:59:59.9999999.