Time format from MS Access/PHP Query

[wellscam]

Hi!

 

I am retreiving information from an Access database using PHP, and having a problem displaying the time.

 

Here is my Query and the line that returns the time:

          

$sql0 = "SELECT * FROM AllInfo WHERE Extension = '$ex' AND Date=#$id#";

echo '<td><center>'.$row['Time'].'</center></td>'; 

 

And this is what it returns:

 

1899-12-30 06:31:00

 

I can't figure out how to make the time (1899-12-30 06:31:00) show up with just the time (06:31). I have read the overview in the code repository, but it just deals with MySql timestamps and this is from an Access Database. Everything I try just breaks my page.

 

Help!! ???

[ober]

try:

echo '<td><center>'.date("h:i", strtotime($row['Time'])).'</center></td>'; 

[wellscam]

That didn't work for my Time date, but I had another column called DateTime that it worked perfectly for...thank you so much!!

[ober]

What is the data format on the field in the database?

[wellscam]

I'm not sure, but that's okay, I can just change my query to use the data from the field that it does work on and get the results I need.