Date - Time

[Admin]

/*
Returns a MySQL zero (NULL) date
*/
function mysql_zerodate()
{
    return '0000-00-00 00:00:00';
}
/*
Converts a MySQL date into an european date format: dd/mm/yyyy
n = mysql2eu_date("2003-11-03 22:13:16"); 
*/
function mysql2eu_date($var)
{
    return substr($var, 8, 2) . '/' . substr($var, 5, 2) . '/' . substr($var, 0, 4);
}
/*
Converts a MySQL time into an european time format: hh.mm.ss
n = mysql2eu_time("2003-11-03 22:13:16"); 
*/
function mysql2eu_time($var)
{
    return substr($var, 11, 2) . '.' . substr($var, 14, 2) . '.' . substr($var, 17, 2);
}
/*
Converts an european date into a MySQL date format: yyyy-mm-dd 00:00:00
n = eu2mysql_date("03/01/2003"); 
*/
function eu2mysql_date($var)
{
    $var = explode('/', $var);
 
    if(strlen($var[2]) == 2) // if year has 2 chars
    {
        $var[2] = "20$var[2]";
    }
 
    if(strlen($var[1]) == 1) // if month has 1 char
    {
        $var[1] = "0$var[1]";
    }
 
    if(strlen($var[0]) == 1) // if day has 1 char
    {
        $var[0] = "0$var[0]";
    }
 
    return "$var[2]-$var[1]-$var[0] 00:00:00";    
}