Daily Archives: Sunday, December 5, 2004

MySQL data format to display format in PHP

Easty way to convert 2004-12-05 style date (mysql) to December 5, 2004 in PHP //format date for printing //I already have variable $mysqlDate which is 2004-12-05 //Remove the ‘-’ from the standar MySQL sate format list($Year,$Month,$Day) = split(‘-’,$mysqlDate); //Create a UNIX style timestamp from the result $stampeddate = mktime(12,0,0,$Month,$Day,$Year); $displayDate = date(“F j, Y”,$stampeddate); print [...]

Posted in Linux, Mac, and LAMP Open Source | 1 Comment
  • Welcome to Daigo’s Daily Digital Diorama. I blog about... whatever that comes to my mind.
  • Change color

    Purple Red Green Blue No Style

  • Archives

  • Calendar

    December 2004
    M T W T F S S
    « Nov   Jan »
     12345
    6789101112
    13141516171819
    20212223242526
    2728293031  
  • Categories