php+mssql: date problem

[eomer]

Hi all,

Hope you can help on this one....

I have a date in a mssql table, column is "datetime 8", format is the following:
01/15/2003 3:14:25 PM

When I perform a query to retrieve one of those dates, and echo it in a web page, I get it in the following format:
Dec 19 2002 8:00AM

How can I get back to this format: 01/15/2003?
Is there a setting in php, or in mssql that I should change, or a workaround?

Thank's in advance,

Nicolas

[YappyDog]

Assuming that it is just the format you are concerned about, and your select statement really isn't changing the date by about a month, you should be able to use the convert() function in your select statement.

Select convert(char(10), yourDateColumn, 101) from yourTable

the "101" specifies what format you want to get it back in.

101 = mm/dd/yy
108 = hh:mm:ss

[eomer]

Exactly what I was looking for!!!

Thank you very much...