mysql timestamp to php display

lbunnell · January 18th, 2005, 04:45 PM

Teaching myself to program in php....

I have a timestamp in my mysql database that looks like this: 20041113105908. I'd like to display it to look like this 11/13/2003 in one column and 10:59:08 in another.

Here's what I've got:

<?php echo date('m/d/y', strtotime($row_rsUsers['EntryDate'])); ?>

and

<?php echo date('H:i:s', strtotime($row_rsUsers['EntryDate'])); ?>

but this doesn't seem to get it. What am I doing wrong.

Thanks,

Lawrence

Snib · January 18th, 2005, 05:59 PM

Try this:

Code:

$date = $row_rsUsers['EntryDate'];

$year = substr($date,0,4);
$month = substr($date,4,2);
$day = substr($date,6,2);
$hour = substr($date,8,2);
$minute = substr($date,10,2);
$second = substr($date,12,2);

//then echo them how you wish
echo $month."/".$day."/".$year;
echo $hour.":".$minute.":".$second;

hth,

-Snib - http://www.snibworks.com
Where will you be in 100 years?

nikolai · January 20th, 2005, 05:55 PM

What is the data type of your MySQL column? If it's the DATETIME type, there are LOTS of mysql functions you can use in your SQL query to format the date however you want.

If it's an integer, then using arithmetic operations will probably be faster and more efficient than using the substr() method posted above. If it's a string, then you're more or less stuck slicing up the string.

You can do this using substr() as above or using a regular expression matching function, like preg_match().

// year month day hour minute second
preg_match('/(\d{4})(\d{2})(\d{2})(\d{2})(\d{2})(\d{2})/',
           $your_date_string,
           $matches);

$matches is an array that will contain all the matched strings.

$matches[0] will be the entire original string.
$matches[1] will be the year,
$matches[2] will be the month,
  ... and so on.

http://www.php.net/preg_match

Take care,

Nik
http://www.bigaction.org/