数据库是sqlserver2000,表中一个字段是datetime类型
想要查寻比2007-11-7 17:56:27近的所有记录,在jdbc中是这样写的
ResultSet rs=con.createStatement().executeQuery(
"select * from tb where BeginTime >2007-11-7 17:56:27");
结果出错
该怎么写呢
想要查寻比2007-11-7 17:56:27近的所有记录,在jdbc中是这样写的
ResultSet rs=con.createStatement().executeQuery(
"select * from tb where BeginTime >2007-11-7 17:56:27");
结果出错
该怎么写呢
TO_DATE(char[,'fmt']):将字符串形式的日期转换成DATE型的日期。
在oracle里有to_date()
没用用过sqlserver不清楚
select * from table where datetime between convert(datetime,'2006-04-01') and convert(datetime,'2006-04-05')
select * from table where datetime between convert(datetime,'2006-04-01') and convert(datetime,'2006-04-05')