c# oracle语句怎么传参数

Question

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

这里面的时间我想编程参数，请问要怎么传参数啊

Answer 1

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");