Date and Time ?

[DjDanHayden]

PHP Code:

$challenges=mysql_query("SELECT challid,challgrid,challgdid,challgrname,challgdname,DATE_FORMAT(created,'%M %d'),DATE_FORMAT(created,'%l:%i') FROM challenges WHERE challgrid='$team[id]' OR challgdid='$team[id]' ORDER BY created DESC");
                    while(list($challid,$challgrid,$challgdid,$challgrname,$challgdname,$created,$time)=mysql_fetch_row($challenges)) 


I want the varaible $time to only show the time, it keeps outputting the date before it.

Can anyone help ?

[Fou-Lu]

How are you printing it? DATE_FORMAT of %l:%i should just be 1:14 for example (you may want to add in an %p as well to tell if its AM or PM).

[DjDanHayden]

Originally Posted by Fou-Lu

How are you printing it? DATE_FORMAT of %l:%i should just be 1:14 for example (you may want to add in an %p as well to tell if its AM or PM).

This is what it prints: 2012-01-23 15:00:00


All i want is the time...

[Fou-Lu]

yes, and I'm saying that the SQL doesn't appear to do that. What I mean is what code are you using to actually print this out?