mysql datetime

Question

QryString = select Distinct convert(nvarchar(10)examDate103) as examDate from TRX.studentDetails; what is equivalent in MYSQL

Sanjeeb Lenka · Answer

i am not familiar with Mysql try this it may help you Select DATE_FORMAT(STR_TO_DATE(datestring '%d/%m/%Y') '%Y-%m-%d') for more details check http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_date-format

Iftikar Hussain · Answer

Hi Try like this you can have format option select Distinct CONVERT( examDate  nvarchar(10) ) as examDate from TRX.studentDetails refer below link for more option http://www.geeksengine.com/database/single-row-functions/conversion-functions.php Regards Iftikar