[RESOLVED] Date format

[I_Love_My_Vans]

Its back to basics i think

My datae is stored in MySQL database in this format DD-MM-YYYY HH-MM-SS (the timestamp format)

I need to format this and preferable outside of the MySQL query statement, now what formatting function do i use, i have tried various, with little result.

Cheers people

[I_Love_My_Vans]

I have solved the problem by creating a function to take the time from the timestamp, split it up, and format it using date and mktime. I have included it for future refernce,m if anyone spots an issue, gives us a shout

function format_date($timestamp_date='') 
{
    if($timestamp_date=='')
    {    
        // Return if no variables passed
        return;
    }
    else
    {    
        // Split up date and time
        $date_time = split(" ", $timestamp_date); 
        
        // Split up date
        $date = split("-", $date_time[0]);
        
        // Split up time
        $time = split("-", $date_time[1]);
        
        $result=date("l jS F Y", mktime($time[0], $time[1], $time[2], $date[1], $date[2], $date[0]));
    }
    return $result;
    
} 

[kows]

if I were you, I'd just store them as unix timestamps and convert them to whatever I need to at runtime. It depends what you're comfortable with, I guess.

[I_Love_My_Vans]

Yes i was told this before by visualad, however im using phpMyAdmin, and i cant seem to find the unix timestamp option :O

[kows]

when you're creating a table you just need to make your date fields an integer that holds 11 figures (ie: int(11)) instead of "date" or "timestamp" types.