<?php echo date("m/d/Y", strtotime($row_consumersoffer['cat_coupon_expdate'])); ?>
http://www.webassist.com/forums/posts.php?id=2877
:-)
Some time ago I did put up a tutorial for date formatting (examples using both server date as well as date stored in a database...here was the original tutorial: http://www.webassist.com/forums/posts.php?id=17179
Then if you use the documentation from the official php website: http://www.php.net/manual/en/function.date.php
you can adjust the format to anything you like :)