date format with mssql

sd1

hello all!
i'm using php & mssql server.
when i try to input a datetime field i get this format:

2 dec 2003. i want it to be: 02/12/2003

i tried to use convert in the query field but it didn't help

any help will be regraded

shai

tomhath

CONVERT is what you want. Should be something like:

CONVERT(varchar, theDate, 101)

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ca-co_2f3o.asp

sd1

it is not working for me

tomhath

What did you try (post your code)? And what happened when you ran it?

sd1

my query:
$query = "SELECT *,CONVERT(varchar(10), closeDate, 101) FROM tblGames WHERE status='1' ORDER BY 'closeDate' DESC";
$result = mssql_query($query) or die(mssql_get_last_message());

my row:
$row = mssql_fetch_array($result);

then:
echo $row[closeDate];

then i get:
2 Dec 2003 instead of: 2/12/2003

tomhath

You echoed the original (not converted) column, the output of the CONVERT function is another field in the result set:

$query = "SELECT *,CONVERT(varchar(10), closeDate, 101) as convertDate
FROM tblGames WHERE status='1' ORDER BY 'closeDate' DESC"; 
$result = mssql_query($query) or die(mssql_get_last_message()); 
...
$row = mssql_fetch_array($result); 
...
echo $row[convertDate];