[SOLVED] Basic datetime question

[papaface]

Hello,

I know this is simple, but ive forgotten how to do it.

How do I convert a date from mysql like "2007-02-24 03:58:08" into "03:58:08" ?

 

Thanks

[paul2463]

if you mean you only want to pull the time part from the database then

 

select DATE_FORMAT(dbdate, '%H:%i:%s');

//outputs 03:58:08 from the database entry 2007-02-24 03:58:08

[papaface]

where would I put that?

Currently my data is taken from the db like this:

$selectposts = mysql_query("select posts_name,posts_content,submitted_date from posts where shoutboxes_unique_id='{$_id}' order by submitted_date desc LIMIT $_start, $_limit");

 

submitted_date is the date i want to format

[paul2463]

$selectposts = mysql_query("select posts_name,posts_content,DATE_FORMAT(submitted_date,'%H:%i:%s') AS fdate
from posts 
where shoutboxes_unique_id='{$_id}' 
order by submitted_date desc LIMIT $_start, $_limit");

//the $row['fdate'] would be the formatted date

[papaface]

Thanks, works perfectly.