datetime field from sql server

[Anon]

Hi,

I have a strange problem occuring, and I
think I must be missing something basic.
I'm using SQL Server, but I think the data
is the same in MySQL.

A field with a data type of
datetime is populated with a value,
2002-02-04 15:27:31.047 When I query
the table and return and display the
value, it displays as Feb 4 2002 15:27:31:047

My question is, why is the format different?
I want to take the format and display it
in mm/dd/ccyy format, which more difficult
when displayed as Feb 4 ...

Any idea why the format changes?

Thanks,

Tim

[Anon]

try doing something like here http://www.php.net/manual/en/function.date.php . you would use a $blah=date("dateformat",mktime("sqltimestamp");