[SOLVED] Date formatting

[damian0612]

Hi

 

I am havng problems converting dates to the format I want.  I currently run an SQL query with the following:

 

SELECT CONVERT_TZ(ItemPubDate_t, '+00:00', '+1:00'),ItemTitle,ItemLink,ItemSourceURL 
FROM feedItems 
WHERE DATEDIFF(NOW(), `ItemPubDate_t`) = 0  
ORDER BY `ItemPubDate_t` DESC

 

I then display the results as follows:

 

	echo "<tr><td>$row[0] <A href=$row[3]>$row[1]</A> $linksource</td></tr>";} 

 

The field ItemPubDate_t is a datetime field and currently returns the date as '2009-04-20 10:23:20'.  I want to convert the ItemPubDate_t to display the time only.  I can't do this in the query using:

 

SELECT date_format(`ItemPubDate_t`,'%H:%i')

 

as I am already querying it and adding one hour to times.  I would like to know how I can do this using php?

 

Mant thanks

Damian

[Yesideez]

Best thing to use is PHP's date() function:

 

http://uk.php.net/date

 

$val='2009-04-20 10:23:20';
echo date('H:i:s',strtotime($val));

[damian0612]

Thank you so much, works perfectly