How to find the Max Date from the Table

[Inbaraj]

Hi...

I have a Table in that i have inserted the DATE as VARCHAR now in that i Want to get the Max Date. I am new to MySQL Plz help me how to find the max date.

with regard
Inbaraj.D

[amitpatel66]

Hi...

I have a Table in that i have inserted the DATE as VARCHAR now in that i Want to get the Max Date. I am new to MySQL Plz help me how to find the max date.

with regard
Inbaraj.D

Could you please show which format the datas are stored in the table as varchar?....DDMMYYYY or MMDDRR??

[Inbaraj]

Could you please show which format the datas are stored in the table as varchar?....DDMMYYYY or MMDDRR??

hi..

It is stored in the MMDDYYYY format.

with reg
Inabraj.D

[mwasif]

This query will return the desired results

SELECT MAX(STR_TO_DATE(varchar_date, '%m%d%Y')) FROM table