mysql, reformat data inside select sentence

Question

my question may duplicated, I researched but I couldn't find out the answer I need.

My question is how can I re-formatting data from mysql select query.

comlum_01 is Char and data like 07/25/2013 or 7/25/2013.

I want to change query data to '20130725'.

Below is the sql sentence I want to make, change and put data in comlum new_comlum

Select A.comlum_01, reformat(A.comlum_01) as new_comlum from table_01 A;

this one looks like similar but...

Thank you very much for your help.

are you looking for this stackoverflow.com/questions/1921574/… ? — Nithesh Narayanan
– Nithesh Narayanan, Commented Jul 26, 2013 at 4:59

Akhil · Accepted Answer · 2013-07-26 04:59:13Z

2

SELECT A.comlum_01, DATE_FORMAT(str_to_date(A.comlum_01, '%m/%d/%Y'), '%Y%m%d') AS New_comlum FROM table_01 A;

answered Jul 26, 2013 at 4:59

2,60225 silver badges37 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1