Welcome Guest, Not a member yet? Register   Sign In
Date Library - Suggestions?
#5

[eluser]kevinprince[/eluser]
MYSQL to HUMAN be this UK or US

Ive got them written below


Code:
/**
*
*Take a MYSQL Timestamp and convert to a British Date
*
*/
function mysql_to_british($date)
{
            if ($date == "0000-00-00") {
                $date = "";
                return $date; } else
            {
            $unix = mysql_to_unix($date);
            $date = date("d/m/Y", $unix);
            return $date; }
}

/**
*
*Take a British Dateand convert to a MYSQL Timestamp
*
*/

function british_to_mysql($date){
    
    if ($date == "") {
    
    $date = "";
    return $date;
    
    } else {
    
    $bits = explode("/", $date);
    $dob_epoch = mktime(0, 0, 0, $bits[1], $bits[0], $bits[2]);
    $date = date("Y-m-d", $dob_epoch);
    
    return $date;
    }


Messages In This Thread
Date Library - Suggestions? - by El Forum - 01-31-2008, 07:35 AM
Date Library - Suggestions? - by El Forum - 01-31-2008, 08:13 AM
Date Library - Suggestions? - by El Forum - 01-31-2008, 09:43 AM
Date Library - Suggestions? - by El Forum - 01-31-2008, 10:15 AM
Date Library - Suggestions? - by El Forum - 01-31-2008, 01:10 PM
Date Library - Suggestions? - by El Forum - 01-31-2008, 04:45 PM
Date Library - Suggestions? - by El Forum - 02-18-2008, 07:00 PM
Date Library - Suggestions? - by El Forum - 02-18-2008, 07:23 PM
Date Library - Suggestions? - by El Forum - 02-18-2008, 07:51 PM
Date Library - Suggestions? - by El Forum - 12-18-2010, 08:46 PM
Date Library - Suggestions? - by El Forum - 12-21-2010, 12:36 AM



Theme © iAndrew 2016 - Forum software by © MyBB