Now with PHP + ADO + Access database, compare time encountered problems
The Time field in the Access database stores the temporal data in coledatetime format.
The following two lines of code are code for the "Time" field that is written to the database during MFC programming
COleDateTime Ct=coledatetime::getcurrenttime ();
M_precordset_record->putcollect ("Time", _variant_t (CT));
-------------------------------------------------------
The following is the date I want to filter SQL, but in fact sqlstr this write is problematic, PHP execution error, want to ask how to write is correct.
$SQLSTR = "SELECT * from record where namestr= ' $sensor ' and time> ' 2014/01/15 '";
$rsRecord 1->open ($sqlstr, $conn 1,1,1);
Reply to discussion (solution)
$SQLSTR = "SELECT * from record where namestr= ' $sensor ' and time> #2014 -01-15#";
$SQLSTR = "SELECT * from record where namestr= ' $sensor ' and time> #2014 -01-15#";
Thank you moderator, this is really available, knot posts
