Intuit interview question

SQL date function question and how to convert data types