我知道BETWEEN的功能是查找满足xx和yy之间的所有记录。
但我要查找的字段indate是个“日期时间”类型的,如“03-5-11 9:01:03”
可是我只写前面的日期查找不到结果,加上后面时间呢,又有错误, 请看 下面:
"Delete From userlist Where indate BETWEEN 03-01-01 00:00:00 AND 03-05-11 00:00:00"
(这样会提示:语法错误 操作符丢失)
或
"Delete From userlist Where indate BETWEEN 03-01-01 AND 03-05-11 "
(这样没有错误,但没有查找到任何记录)请高手帮我解决一下。谢谢!
但我要查找的字段indate是个“日期时间”类型的,如“03-5-11 9:01:03”
可是我只写前面的日期查找不到结果,加上后面时间呢,又有错误, 请看 下面:
"Delete From userlist Where indate BETWEEN 03-01-01 00:00:00 AND 03-05-11 00:00:00"
(这样会提示:语法错误 操作符丢失)
或
"Delete From userlist Where indate BETWEEN 03-01-01 AND 03-05-11 "
(这样没有错误,但没有查找到任何记录)请高手帮我解决一下。谢谢!
Delete From userlist Where indate BETWEEN convert(datetime,'03.01.01',102) AND convert(datetime,'03.05.11',102)
或Where indate >'03-01-01 00:00:00' and indate <'03-05-11 00:00:00'"
access中日期两边加#
sql server 中就用convert
oracle要用to_char
convert函数:CONVERT (data_type[(length)], expression [, style])102代表的是输出的格式!yymmdd格式的!
Delete From userlist Where indate BETWEEN cdate('03-01-01 00:00:00') AND cdate('03-05-11 00:00:00')