Formating a timestamp problem

nivek9991

Hello All,
I have a timestamp in my sql db, which is in sql timestamp format (from what I've read, meaning it's not in unix format).
Here is an example of what I have:
20030510184400

Now when I scoop that out of the DB (along with other fields), I wanna display it as:
Mar 10th 2003 6:44pm

I've played around with mktime, but I could not get it to format correctly.

What is a good approach for this?
Thanks

WinterDragon

simple! do this..

$dtime = date("M jS Y g:Ha", $timestamp);

BAM BAM!

Hope it helps.

Btw, that will make it just like you wanted it... (just like you posted it, the date that is.)

nivek9991

Actually, it produces this:
Jan 18th 2038 10:22pm

For all times, no matter what the time stamp is...

WinterDragon

uhhhhhhh..... I just tried this exact

<?php
$timestamp = time();
$dtime = date("M jS Y g:Ha", $timestamp);
echo $dtime;
?>

Returned:

May 10th 2003 7:19pm

I dunno whats wrong with yours 😛

WinterDragon

how are you getting that timestamp btw? Are you combining something, or what? Looks like you have 2 timestamps or something in there...

nivek9991

As I said in my first post (I hope people read the entire posts), my timestamp is in the format:
20030510184400

That is the standard MySQL timestamp format for a field with the "timestamp" property.

WinterDragon

Ok after wrestling with it for awhile... here...

<?php
$dt = 20030510184400;
$year = mysqlShowTime($dt);
echo $year;
function mysqlShowTime($timestamp) {
$year = substr($timestamp, 0, 4);
$month = substr($timestamp, 4, 2);
$day = substr($timestamp, 6, 2);
$hour = substr($timestamp, 8, 2);
$minutes = substr($timestamp, 10, 2);
$seconds = substr($timestamp, 12, 2);
$show = mktime($hour, $minutes, $seconds, $month, $day, $year);
$showTime = date("M jS Y g:Ha", $show);
return $showTime;
}
?>

I HOPE YOU'RE HAPPY!! cries It wokrs btw...

nivek9991

Thank you very much.
I was hoping there was something easier than that, but I guess since MySQL doesn't store timestamps in Unix format, that code is required 🙂

Thanks again!

WinterDragon

damn that took awhile 😛

You're welcome.