SELECT ID,CONTENT FROM JC_T_QXYJXX WHERE CREATTIME BETWEEN TO_DATE('2016-08-26 00:00:00','yyyy-mm-dd hh24:mi:ss') AND TO_DATE('2016-08-26 23:59:59','yyyy-mm-dd hh24:mi:ss') ORDER BY ID DESC
这里面的时间我想编程参数,请问要怎么传参数啊
SELECT ID,CONTENT FROM JC_T_QXYJXX WHERE CREATTIME BETWEEN TO_DATE('2016-08-26 00:00:00','yyyy-mm-dd hh24:mi:ss') AND TO_DATE('2016-08-26 23:59:59','yyyy-mm-dd hh24:mi:ss') ORDER BY ID DESC
这里面的时间我想编程参数,请问要怎么传参数啊
string sql = string.Format("SELECT ID,CONTENT FROM JC_T_QXYJXX WHERE CREATTIME BETWEEN TO_DATE('{0},'yyyy-mm-dd hh24:mi:ss') AND TO_DATE('{1}','yyyy-mm-dd hh24:mi:ss') ORDER BY ID DESC", "2016-08-26 00:00:00", "2016-08-26 23:59:59");