How to display a date stored in a table with the desired way?

mikek12004

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

Expand|Select|Wrap|Line Numbers

$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

Expand|Select|Wrap|Line Numbers

CONVERT(varchar(20),'2008-07-28 14:47:00' ,104)

but still it does not show the desired format any ideas?

code green

"It did not work" is not very helpful. What did you get?
The PHP syntax looks like it will fail to me.
Was there an error?

ck9663

Since you're looping through the result set, can't PHP handle it rather than SQL Server?

-- CK

iburyak

Try this:

Expand|Select|Wrap|Line Numbers

select CONVERT(varchar(20),convert(datetime, '2008-07-28 14:47:00') ,103)

Good Luck.

How to display a date stored in a table with the desired way?

Post your reply

Similar topics