当前位置: 技术问答>java相关
java 中如何用SQL 查时间区间???急!!!!!
来源: 互联网 发布时间:2015-11-06
本文导语: java 中如何用SQL 查时间区间???急!!!!! | String date = "aaa"; String date1 = "bbb"; SELECT * FROM TABLE WHERE to_char(table.date,'yyyy/mm/dd')>='" +date+ "' and to_char(table.date,'yyyy/mm/dd')
java 中如何用SQL 查时间区间???急!!!!!
|
String date = "aaa";
String date1 = "bbb";
SELECT * FROM TABLE
WHERE
to_char(table.date,'yyyy/mm/dd')>='" +date+ "' and
to_char(table.date,'yyyy/mm/dd')
String date1 = "bbb";
SELECT * FROM TABLE
WHERE
to_char(table.date,'yyyy/mm/dd')>='" +date+ "' and
to_char(table.date,'yyyy/mm/dd')