[MySQL] datetime ---> number

[wwhassupp]

Hi!
I've a table with a coloum "dob", the type of it is datetime.

I could like to convert the datetime to number. For example, 1980-12-28 00:00, I want it convert to 19801228.

How can I do it in MySQL (through phpMyAdmin)?

[see also this thread]

Thanks in advance!!

[NogDog]

SELECT DATE_FORMAT(`dob`, '%Y%m%d') AS `date_ymd` FROM `table_name`;

[wwhassupp]

SELECT DATE_FORMAT(`dob`, '%Y%m%d') AS `date_ymd` FROM `table_name`;

Thanks for your reply!

What else if I want to MD5 it?

I can do the following.

SELECT MD5(dob) FROM table_name

But, how can I do MD5 with your query?
I've tested the below, but it not work.

SELECT MD5(DATE_FORMAT(`dob`, '%Y%m%d') AS `date_ymd`) FROM table_name

Thanks again!

[wwhassupp]

I've got the answer.

SELECT MD5(DATE_FORMAT(`dob`, '%Y%m%d')) FROM table_name