How do i get the date value out of mysql (format 0000-00-00) to a string "Month, Day Year")

    i use this, youll want to use something similar
    $date = strtotime(substr($date,5,2).'/'.
    substr($date,8,2).'/'.
    substr($date,0,4).' '.
    substr($date,11,5));
    $date = date("M j, Y, g:i A", $date);

      6 months later

      it suprises the heck out of me, that this does not work for me; it gives me 1969 date.

        4 months later

        The script work up very well, may be u take the system date.

          I follow the script that u sended but i found some error.
          This is the script that i insert

          $datum = strtotime(substr($datum,5,2).'/'.
          substr($datum,8,2).'/'.
          substr($datum,0,4).' '.
          substr($datum,11,5));
          $datum = date("M j, Y, g:i A", $datum);

          If i send this event for 1 to 1 person, this script is process well, but after send this date for 1 to many, then this script is taking the mySql system date --31 Dec 1969.

          How to correct this method and allow the date display well?

          Thanks for help

          thanks & regard,
          vennly

            im not sure i understand your question.

            this was a pretty old post anyway, you should now be able to use:

            $datum = date("M j, Y, g:i A", strtotime($datum));

              it's great, thanks

                Write a Reply...