Date Re-Format

[ab4net]

hi all,
i have a small program, that retrives data from MSSQL table ...
any way, the problem is, there is a date column and when i retrive the date from that column it appears like : "4 January 2006 12:00AM"
and i want to make it (after the retrival) looks like : 04/01/2006
is there a way please !! am stucl in here !!! please help ...
NOTE: i dont have the ability to change any thing in the database as well as the tables, just can read from them and am using the WHILE loop to get the data.

thanks in advance,

[duckduckgoose]

You can format it when you query your db:

SELECT DATE_FORMAT(Column_Name, '%m/%d/%y') AS FormattedDate FROM TableName;

[ab4net]

actually the SQL sentax is incorrect, returns error when my SQL because it is a long SQL statement with lot of JOINS, by the way it is MS-SQL not MySQL
so please guys any help !!!

[ab4net]

ok, any one can advice is this problem can be solved, if iconvert the date to array and refrase the array ... i have the idea but any help ?!