Displaying DATETIME

luiddog

Hey, I have time saved in mysql as a DATETIME and have been trying to change the display from YYYY-DD-MM HH:MM:SS to anything else.

I have the datetime coming in as
<?php echo $row_rsEvent['EventTime']; ?>

I've tried everything. Any ideas?

yelvington

Originally posted by luiddog

I've tried everything. Any ideas?

http://www.mysql.com/doc/en/Date_and_time_functions.html

Change your SELECT statement to convert the retrieved value to the format you prefer using DATE_FORMAT().

luiddog

I must be doing something wrong. I read the manual but when I add the DATE_FORMAT() it errors. I have the following. Thanks again.

mysql_select_db($database_EventConnection, $EventConnection);
$query_rsEvent = "SELECT * FROM tblEvent ORDER BY EventTime ";
$rsEvent = mysql_query($query_rsEvent , $EventConnection) or die(mysql_error());
$row_rsEvent = mysql_fetch_assoc($rsEvent);
$totalRows_rsEvent = mysql_num_rows($rsEvent);
?>

<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<?php do { ?>
<?php echo $row_rsEvent['Location']; ?> <?php echo $row_rsEvent['EventTime']; ?><br>
<?php } while ($row_rsEvent = mysql_fetch_assoc($rsEvent)); ?>
<br>
</body>
</html>
<?php

mysql_free_result($rsEvent);
?>

yelvington

$query_rsEvent = "SELECT *, DATE_FORMAT(EventTime, '%H.%i.%S') as MyEventTime FROM tblEvent ORDER BY EventTime ";

Then in your php

echo $row_rsEvent['MyEventTime'];

Result will look like '03.10.2003' ... use any formatting string you like.