php - Different Query Result in SQL Server 2005 -

i have table in sql server 2005, , has column period (datetime).

the value of column period 8/7/2009 12:00:00 am, when query using php script give me output aug 7 2009 12:00am.

why it's not 8/7/2009 12:00:00 am ???

thank you

your question reads this:

the value of column period is
{ date, year 2009 month august day 7th @ 12:00 am}
when query using php script give me output "aug 7 2009 12:00am", i.e. 1 representation of date.
why it's not "8/7/2009 12:00:00 am", i.e. representation of date

a datetime represents point in time. specific concept. comparing 2 separate representations of datetime, or in other words, 2 ways of formatting datetime value textual string.

the issue trying solve then, "how format datetime string in php"? answer refer date_format (aka datetime::format) function

to wit, display specifier 8/7/2009 12:00:00 am n/j/y h:i:s a.