date format...PLS HELP

[outback]

Hi all,

I've been trying to change the date format of my website for a long time nowand nothing seems to work. I've tried to change it on MySQL but I'm not getting it right.

here is the line of code I'm using to call the date from the database:


<?php echo $row_rs_nw['date'];?>


what I need is to change the format from yyyy/mm/dd to mm/dd/yyyy....

PLS HELP!!! thanks for the attention!!

[NeoDreamer]

I usually store my dates in MySQL as Unix timestamp, so I'd do:



echo date('m/d/Y', $row_rs_nw['date']);


But you're storing your date as some other weird format so, try:



echo substr($row_rs_nw['date'], 5, 2) . '/' .
substr($row_rs_nw['date'], 8, 2) . '/' .
substr($row_rs_nw['date'], 0, 4);

[outback]

Thank u!!!!!