DATABASE FUNDAMENTALS
WHAT IS DATABASE MANAGEMENT
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
The best data type to choose for date of birth would be
|
|
Number
|
|
|
Text
|
|
|
Date/Time
|
|
|
Currency
|
Explanation:
Detailed explanation-1: -LocalDate (or logically-equivalent classes likes org. joda. time. LocalDate ) is the best way to represent a date-of-birth (DOB) in Java code.
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 DATETIME type is used for values that contain both date and time parts. MySQL retrieves and displays DATETIME values in ‘ YYYY-MM-DD hh:mm:ss ‘ format. The supported range is ‘1000-01-01 00:00:00’ to ‘9999-12-31 23:59:59’ . The TIMESTAMP data type is used for values that contain both date and time parts.
There is 1 question to complete.