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";
}