Q72 Examine the description of the employees table:
Which query requires explicit data type conversion?
- (A). SELECT join_date FROM employees WHERE join_date > ’10-02-2018′;
- (B). SELECT join_date I I ‘ ‘ II salary FROM employees;
- (C). SELECT SUBSTR(join_date, 1, 2) – 10 FROM employees;
- (D). SELECT join_date + ’20’ FROM employees; SELECT salary * ‘120.50’ FROM employees;
Answer: A