table函數(shù)如何實(shí)現(xiàn)對(duì)兩個(gè)時(shí)間點(diǎn)間的數(shù)據(jù)的查詢(xún)?
sprintf(sql,"select * from shidu1 where dateandtime between to_date( %s,'yyyy-mm-dd hh:mm:ss' ) ,and to_date( %s,'yyyy-mm-dd hh:mm:ss' ),stime,etime);
table函數(shù)如何實(shí)現(xiàn)對(duì)兩個(gè)時(shí)間點(diǎn)間的數(shù)據(jù)的查詢(xún)?
sprintf(sql,"select * from shidu1 where dateandtime between to_date( %s,'yyyy-mm-dd hh:mm:ss' ) ,and to_date( %s,'yyyy-mm-dd hh:mm:ss' ),stime,etime);