mySQL date Format To PHP

[rochellecanale]

hey guys just want to ask how can i format the date in mysql which is YYYY-mm-dd in MM/dd/YYYY in php? because i created a payout module that displays payout transaction and i want to format the date how can i do this? please help me

[rwhite35]

Assuming $dbdate is the date you pulled out of your database, you could use the PHP date() to format the date string.

Code: Select all

$pdate = date("m/d/Y",$dbdate);