Printable View
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 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 :D
PHP Code: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;
}
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.
Yes i was told this before by visualad, however im using phpMyAdmin, and i cant seem to find the unix timestamp option :O
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.