Question

which of the following functions convert character string given in date style, into an equivalent
1)TO DATE {char[FORMAT]}
2)TO NUMER {char[FORMAT]}
3)DATE {char[FORMAT]
4) none of these ​

Answer 1

Answer-1 is correct

Explanation:

Answer 2

Answer: (1) - To_DATE(char[, 'format_model'])

Explanation:

char   ----- char to be converted

format_model   ------- format that will be used to convert char to date.

Example:

select to_date('2000-05-24', 'yyyy/mm/dd') from dual;

Output:

24-May-2000.

Hope it helps!