[Resolved] re-arranging a string

[Butthead]

I have a sql query that is returning a string in the format yyyy-mm-dd (cuz that's how it's stored in the D😎, and it needs to be re-arranged into mm/dd/yy, what would be the easiest way to accomplish this?

[bubblenut]

Check out the Date and Time functions in th manual. Specifically, [man]strtotime()[/man] and [man]date()[/man]

HTH
Bubble

[Butthead]

thanks, I got it with this

$bill_dateW = date("m/d/y", strtotime("$bill_date[$j]"));