I have dates stored in a database with the form of '01/01/2001'. The field is smalldatetime. The output when I return the values ends up being 'Jan 1, 2003 12:00AM' How can I format that value to something that is a little more usefull (Like 'Jan 1, 2003')?

Thanks!

Matthew

In mySQL you can do:

SELECT DATE_FORMAT(date_field_name, "%b %d, %Y") ... FROM ... WHERE ...;

Maybe this also works for MSSQL... or just use mySQL :)

How about echo date("M j, Y",strtotime("Jan 1, 2003 12:00 AM"));

Thanks so much for the help! It ended up working like this:

$Date = date("M j, Y",strtotime("$SmallDateTime"));

Thanks again!

Matthew