Daily Archives: Sunday, December 5, 2004

MySQL data format to display format in PHP

By daigo | Published: Sunday, December 5, 2004
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. This is utterly useless online journal (yes, that was what it was originally called before term "blog") that I've been keeping since 2002. Since it is ".org," my wife once called it a nonprofit nonsense. I use this blog mostly about baseball, and being Japanese man in America. Wondering who the heck Daigo is?

  • Color Switcher

    Purple Red Green Blue No Style

  • My websites

    JapaneseBallPlayers.com
    A bilingual websites dedicated to bring you the information on Major League Baseball players from Japan.

    Go-RedSox.com
    Japanese language blog about Boston Red Sox.

    Daigo Fujiwara portfolio
    My work as graphic designer/web designer.

    Daigo.org
    Personal blog that I've been keeping since 2002.

    Itadakimasu
    I like to eat. And taking photo of it.

  • Calendar

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

  • Past entries

  • Topics that I cover

  • Flickr