[Resolved] time not display correctly

[kav]

input text box2 value e.g 04.00 pm

after submiting, go to the process page to store into mysql

$timefrom=$_POST['time_from'];

$time_from=strtotime($timefrom);

//this is so that i can get the 00:00:00 format coz the data type is TIME in mysql
$time_from=date("h:i:s", $time_from);

$claimquery="INSERT INTO claim VALUES (NULL, '$time_from');

i look at the values in mysql and it is 16:00:00

when i retrieve from it to display using this:

$claimquery="SELECT UNIX_TIMESTAMP(time_from) AS time_from";
$result2=mysql_query($claimquery, $db) or die("Could not execute query");
while($row=mysql_fetch_array($result2))
{
echo "<td>".date("H:i A", $row['time_from'])."</td>";
}

it always shows 8:00 AM.

How come it is not show 4.00 pm?

[cahva]

You can use mysql's time functions for that. No need to convert it to timestamp(and it is time only so you wont be able to get correct datestamp because of missing date):

$claimquery="SELECT date_format(time_from, '%h:%i %p')  AS time_from FROM claim"; 
$result2=mysql_query($claimquery, $db) or die("Could not execute query"); 
while($row=mysql_fetch_array($result2)) 
{ 
echo "<td>".$row['time_from']."</td>"; 
}

[kav]

i tried yours but now it all appear as 12.00 AM. is something wrong?

$claimquery="SELECT *, date_format(overtime_date, '%d-%m-%y') AS overtime_date,
DATE_FORMAT(time_from, '%h:%i %p') AS time_from.....

i am just wondering whether the way i store it into mysql is correct? (first post)

does that DATE_FORMAT() applies to data type DATE , DATETIME and TIMESTAMP only? I am using data type TIME default as 00:00:00
Do i have to change the data type to the any of the three stated and not using TIME?

i am doing a little of reading though from the site u provide

[cahva]

Sorry my bad.. Use TIME_FORMAT instead of DATE_FORMAT

[kav]

Thanks alot..it worked!!! guess i need to keep reading!!