试试这个: select * from table1 where fielddate>='2002-11-10' and fielddate<='2002-11-15'
这样写法不知对不对: select * from tableName datafield where (#year/month/day#) and (#year/month/day#) 我在VC里都是这样用的,但在JAVA里试了一下好像不行,我初学java,很多都不知道,有谁知道,这样用对不对?
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')<='" +date1+ "'
select * from table1 where fielddate>='2002-11-10' and fielddate<='2002-11-15'
select * from tableName datafield where (#year/month/day#) and (#year/month/day#)
我在VC里都是这样用的,但在JAVA里试了一下好像不行,我初学java,很多都不知道,有谁知道,这样用对不对?
String date1 = "bbb";
SELECT * FROM TABLE
WHERE
to_char(table.date,'yyyy/mm/dd')>='" +date+ "' and
to_char(table.date,'yyyy/mm/dd')<='" +date1+ "'