From: "Hans Lellelid" <hans@xxxxxxxxxxxxxx> > Using MySQL DATE_FORMAT() would work, but it's a hack solution; if you > ever wanted to create an English version of your site you would have to > make changes to your data-layer queries -- and that's just not where > that logic belongs. So use UNIX_TIMESTAMP and date() or just use strtotime(). Or go all out and just store the dates in a unix format in an integer column to begin with! The choice is yours... ---John Holems... -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php