replace

[siwy]

how do i convert 02012003 to 01_02_2003? is it possible to do it directly in SELECT statement?

[xblue]

Hi, yes, it's possible.
I'd suggest to run a search for date_format. this should bring up a lot of examples and the link to the mysql page that lists the formatting options.

[siwy]

yeah, it worked for me just fine. thanks