Describe TO_DATE function in mysql?
The TO_DATE function returns a timestamp from a character string that has been interpreted using a character template.TO_DATE is a synonym for TIMESTAMP_FORMAT.
Write a syntax for To_Date function
To_date('2003/07/09', 'yyyy/mm/dd') would return a date value of July 9, 2003.
To_date('070903', 'MMDDYY') would return a date value of July 9, 2003.
SELECT TO_DATE(‘January 15′,’MONTH DD’) “Sample” FROM DUAL