I have a table where I store dates in smalldatetime format like this '2008-07-28 14:47:00' I want in PHP to retrieve these values and display them like '28/07/08' I retrieved the dates from the table and inside the first loop I put
-
$qdate=mssql_query("select CONVERT(varchar(20), '$rcrit[5]', 103)");
-
where $rcrit[5] the variable holding the date, saddly it didnot work I tried in MSSQL to put
- CONVERT(varchar(20),'2008-07-28 14:47:00' ,104)
but still it does not show the desired format any ideas?