COMPUTER SCIENCE AND ENGINEERING
SQL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Which data type should you use for the BIRTHDAY column in STUDENTS table?
|
|
CHAR
|
|
|
VARCHAR2
|
|
|
DATE
|
|
|
NUMBER
|
Explanation:
Detailed explanation-1: -The use of the DATE data type for the birth and death columns is a fairly obvious choice.
Detailed explanation-2: -"DATE” should be good. The DATE type is used for values with a date part but no time part. MySQL retrieves and displays DATE values in ‘YYYY-MM-DD’ format. The supported range is ‘1000-01-01’ to ‘9999-12-31’.
Detailed explanation-3: -The correct format of your date of birth should be in dd/mm/yyyy. For example, if your date of birth is 9th October 1984, then it will be mentioned as 09/10/1984.
There is 1 question to complete.