Retrieve short time out of MS access

[jim]

When I retrieve a time field out of MS Access. I get a negitive 1 The
Access is 2000 can anyone help?


Code






$Query="SELECT * FROM tEvents where start_date between
#".$given_b. "# and #".$given_e. "# order by start_date";

$rs->open ($Query, $DB_Conn, 3 ); // 3=adopenStatic

$start_time = $rs->Fields['start_time']->Value;
$end_time = $rs->Fields['end_time']->Value;