Formatting all date columns in MySQL

AdamBrill

I am looking for a way to format all date columns in MySQL. I currently have something like this:

SELECT DATE_FORMAT(`findamatch`.`dateentered`, '%b %e, %Y') AS `dateentered`,
DATE_FORMAT(`findamatch`.`datetoday`, '%b %e, %Y') AS `datetoday`,
DATE_FORMAT(`findamatch`.`available`, '%b %e, %Y') AS `available`,

and the query goes on, but I would prefer to just format all dates rather than have to do each individually like I am currently doing it. I realize that I could do something like this:

SHOW COLUMNS FROM `findamatch`;

and use PHP to build the next query with the data returned, but I would rather have an all SQL solution if there is one available.

Thanks for looking.

AdamBrill

Well, I was hoping for an all SQL solution, but it doesn't appear that I'm going to get one, so here is my solution using PHP:

<?PHP

mysql_connect("localhost", "root", "pass");
mysql_select_db("db_name");

$sql = "SHOW COLUMNS FROM `tb_name`;";
$results = mysql_query($sql);
$sql = "SELECT *";
while($row = mysql_fetch_assoc($results)){
	if($row['Type'] == "date"){
		$sql .= ",\nDATE_FORMAT(`". $row['Field'] ."`, '%b %e, %Y') AS `". $row['Field'] ."`";
	}
}
$sql .= "FROM `tb_name`;";
$results = mysql_query($sql);
echo "<pre>";
while($row = mysql_fetch_assoc($results)){
	print_r($row);
}
echo "</pre>";
?>

I hope that helps someone!