FUNDAMENTALS OF COMPUTER

SYSTEMS DEVELOPMENT ANALYSIS

SYSTEMS DEVELOPMENT LIFE CYCLES

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Format check can only be used with Date field?
A
True
B
False
C
Either A or B
D
None of the above
Explanation: 

Detailed explanation-1: -SimpleDateFormat – yyyy-M-d For legacy Java application, we use SimpleDateFormat and . setLenient(false) to validate a date format.

Detailed explanation-2: -The JavaScript Date. parse() method is used to check whether the given date is valid or invalid. The function returns NaN if the given date is invalid or else it returns the number of seconds elapsed since January 1, 1970. By this, we can check the validation of the date given.

Detailed explanation-3: -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. TIMESTAMP has a range of ‘1970-01-01 00:00:01’ UTC to ‘2038-01-19 03:14:07’ UTC.

There is 1 question to complete.