How to format the date and time that is obtained from the database

Question

I get the date and time from the database as follows

Date: 20100101 (YYYY / MM / DD) Time: 120912 (HH: MM: SS)

I need to format the date as follows: 20100101 → (2010-10-11) (see to have) "-" between year and month and day

I need to format the time as follows: 120912 → 12:02:12 Suppose I can have time as 62367 from the database

06:23:67

Answer 1

I recommend you convert the data using: http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html

Answer 2

DATE_FORMAT(fieldname,format ) mysql DATE_FORMAT( a.date, '%d-%m-%Y' )