牧师 "SELECT KCM,BT,WTNR,TWSJ,XM,XH,ID,KCH,KXH " + " FROM TEACHER_QUESTION_INFO " + "WHERE JSH1='" + jsh+ "'" + " AND (to_char(TWSJ,'yyyy-mm-dd hh24:mi:ss') >to_char(?,'yyyy-mm-dd hh24:mi:ss')) ORDER BY XH DESC" 还是和以前一样,当天的记录还是为新记录,how can I do??
可每次取的还是当天的新数据,而那个WTSJ已经更新到秒了,数据库里查看以更新,这是为什么??
SELECT KCM,BT,WTNR,TWSJ,XM,XH,ID,KCH,KXH " + " FROM TEACHER_QUESTION_INFO " + "WHERE JSH1='" + jsh+ "'" + " AND to_date(to_char(TWSJ,'yyyy-mm-dd hh24:mi:ss'),'yyyy-mm-dd hh24:mi:ss') > to_date(?,'yyyy-mm-dd hh24:mi:ss')) ORDER BY XH DESC"
http://expert.csdn.net/Expert/FAQ/FAQ_Index.asp?id=185465
牧师
"SELECT KCM,BT,WTNR,TWSJ,XM,XH,ID,KCH,KXH " +
" FROM TEACHER_QUESTION_INFO " +
"WHERE JSH1='" + jsh+ "'" + " AND (to_char(TWSJ,'yyyy-mm-dd hh24:mi:ss') >to_char(?,'yyyy-mm-dd hh24:mi:ss')) ORDER BY XH DESC" 还是和以前一样,当天的记录还是为新记录,how can I do??
" FROM TEACHER_QUESTION_INFO " +
"WHERE JSH1='" + jsh+ "'" + " AND to_date(to_char(TWSJ,'yyyy-mm-dd hh24:mi:ss'),'yyyy-mm-dd hh24:mi:ss') > to_date(?,'yyyy-mm-dd hh24:mi:ss')) ORDER BY XH DESC"
> to_date(sysdate,'yyyy-mm-dd hh24:mi:ss')) ORDER BY XH DESC
*
ERROR 位于第 4 行:
ORA-01861: 文字与格式字符串不匹配