date formatting

[Anon]

I am using SQL Server and the field is set to date/time. When returning the fields from that table using PHP, I get this format:
2002-06-02 00:00:00.000

How can I format that to 06-02-2002? Any ideas?

Thanks,

Seth

[Anon]

try:

<?php
$datetime = "2002-06-02 00:00:00.000";
$date = explode(" ",$datetime);
echo $date[0]; //should print 2002-06-02

$pieces = explode("-",$date[0]);
echo $formatedDate = $pieces[1].$pieces[2].$pieces[0]; //should return your as you wish
?>

did not try it but something like that should do it.

regards ali

[Anon]

actually, you should really use MySQL's DATE_FORMAT() function. It is always faster to pull the data out already formatted rather than pull it out and then formatt it.