MCQs > IT & Programming > MySQL > I would like to retrieve the date with this format : dd/mm/YYYY in a field called btimestamp. Choose the correct way.

MySQL MCQs

I would like to retrieve the date with this format : dd/mm/YYYY in a field called btimestamp. Choose the correct way.

Answer

Correct Answer: SELECT DATE_FORMAT(btimestamp,'%d/%m/%Y') AS bdate FROM ...

Explanation:

Note: This Question is unanswered, help us to find answer for this one

MySQL Skill Assessment

Overall Skill Level-Poor

Your Skill Level: Poor

Retake Quizzes to improve it

search

MySQL Skill Assessment

Overall Skill Level-Poor

Your Skill Level: Poor

Retake Quizzes to improve it