Posted By

rifat on 06/04/10

Tagged

mysql
php

Versions (?)

Last Edited at 06/04/10 07:51pm

Statistics

Viewed 939 times

Favorited by 0 user(s)

Related snippets

MySQL date to PHP timestamp

/ Published in: PHP

Expand | Embed | Plain Text

Copy this code and paste it in your HTML

function mysql2php($str)  {
    list($date, $time) = explode(' ', $str);
    list($year, $month, $day) = explode('-', $date);
    list($hour, $minute, $second) = explode(':', $time);
 
    $timestamp = mktime($hour, $minute, $second, $month, $day, $year);
 
    return $timestamp;
}