Date / Time Formatting

[angela_such]

hi,

Here is my attempt to print a formatted time on my page..

while ($row = mysql_fetch_assoc($result)) {

			$month = substr($row['date'],5,2);
			$day = substr($row['date'],8,2);
			$year = substr($row['date'],0,4);
			echo $month . "/" . $day . "/" . $year ;


			echo date($row['time'], "g:i a");


			echo " ";
		    echo $row['time']; 
			echo "     ";
			echo "<a href='../webinar_register.html'>Register</a>"; 
			echo "<br>";
		}

Here is my results:

Date Time Register
06/20/200714:30:00 14:30:00 Register
07/01/200712:00:00 12:00:00 Register

Why does the date function seam to have NO effect...

Thank you for your assistance in this matter.... I've spend time pouring through the php manual, it's simple I know, but I can't get to the bottom of it...

[shu]

The date() function operates on a integer timestamp, which includes both parts of the date-time. You need to convert you values to an integer first:

...
list($h, $m, $s) = explode(":", $row['time']);
$timestamp = mktime($h, $m, $s, $month, $day, $year);
//The following statement will output the date-time in one swoop.
echo date($timestamp, "m/d/Y g:i a");
...

You might also want to look at the strtotime() function, it might be faster in converting a string to integer timestamp.

[bradgrafelman]

I would probably agree with shu's suggestion of using [man]strtotime/man since it would be a less code:

echo date('m/d/Y g:i a', strtotime($row['date'], $row['time']));