Is there a function to convert dates like :2003-03-10 02:45:47 on the fly to a more friendly format
Like Mon 03-10-2003 02:45:47
regards Thomas
SELECT DATE_FORMAT(date_col, '%a %m-%d-%Y %r') FROM tbl_name
