retrieving date from database

[Anon]

hello
i m trying to retreive the date from the database in the format dd/mm/yyyy and like to insert the date in the same above format dd/mm/yyyy but while retreiving it is displaying yyyy-mm-dd could anybody help me out
thanx
sowmya

[chowdary]

Hi Sowmya,
If displaying the date value is only the problem then try this

$qry="SELECT $fldname1,$fldname2,DATE_FORMAT($dt_field,'%d-%m-%Y) dt from $ tablename";

Here $fldname1,$fldname2...are if you want to get the other data also

And $dt_field is the Field Name in your database and "dt" is to get the data i.e you need to this as field name ex:$row["dt"]

Alternatively you can do this

once you got the date value from the database you need to format that
i.e if $db_dt is the variable you have the date value then
$dt_arr=explode("-",$db_dt);
$new_dt=$dt_arr[2]."-".$dt_arr[1]."-".$dt_arr[0];

Now you have the date in the format you wish.

Hope you got it.....Enjoy