QryString = "select Distinct convert(nvarchar(10),examDate,103) as examDate from TRX.studentDetails";
what is equivalent in MYSQL
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Sanjeeb LenkaPosted Jul 30, 2013, 5:57 AM
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 HussainPosted Jul 30, 2013, 5:55 AM
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