[SOLVED] display time from sql db

[trpplayer79]

Dear,

 

I have a mysql database.

in this db I have a time stored from a meeting.

when I get the time out of the db and display it it is HH:MM:SS but I only want HH:MM

I've searched for a sollution but can't find it.

can somebody please give me a sollution for this problem

maybe I have to store only the HH:MM in the DB but I didn't find anything about how I can do this.

 

greetz

 

Trpplayer

[wildteen88]

If you only want the hour and minutes displayed you can just drop of the seconds part like so:

$time = '12:45:00';

list($hours, $minutes, $seconds) = explode(':', $time);

echo $hours . ':' . $minutes; // 12:45

[trq]

Or, format the time in your query.

 

SELECT DATE_FORMAT(fld,"%h:%i") AS formattedtime FROM tbl;

[trpplayer79]

but how do I integraet this is my current sql string?

my current sql string is this:

SELECT * FROM [table][tr][td] WHERE datum >= CURDATE( ) AND iedereen = 1 ORDER BY datum';

the hour field is "starthour".

[wildteen88]

Whats the filed that contains the time?

You place Thorpes snippet in the SELECT statment, eg:

 

SELECT *, DATE_FORMAT(fld,"%h:%i") AS formattedtime FROM WHERE datum >= CURDATE( ) AND iedereen = 1 ORDER BY datum';

change the highlighted text in red to the column which contains the time. Then use $row['formattedtime'] to get the formatted time

[trpplayer79]

THANK YOU for you help.

it workes.