OCP CBT Question 495

Please solve the following question.

Examine the following SQL statement:

sqlSELECT TO_CHAR(SYSDATE, 'YYYY/MM/DD HH24:MI:SS') FROM DUAL;

It will display the current date and time in the format 'YYYY/MM/DD HH24:MI:SS'.

It will display the current date and time in the format 'YYYY-MM-DD HH:MI:SS AM'.

It will return an error because 'HH24' is not a valid format element.

It will display only the current date, not the time.