Hi All,
I have a time field in my MS Access Database call TimeText and is formatted as Short Time.
The value of this field is 14:00
When I retrieve the field from the Database using ADO and
$doc_root = $_SERVER['DOCUMENT_ROOT'];
$dbc = new COM("ADODB.Connection");
$dbc->Open("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=$doc_root/cgi-bin/DytecnaPeople.mdb");
$SQLText = "SELECT * FROM IntMeet";
$rs = $dbc->Execute($SQLText);
$TimeText = $rs->Fields["TimeText"]->value;
I keep getting -1 as the returned Value? Why -1 and noy 14:00
I have tred formatting it with the date function but always gets unexpected error in date() and if I use strtotime I get an error strtotime() called with empty time parameter
Any ideas?
