帮我写个Sql语句

[xiyupiaopiao]

我的数据库一个date字段,一个time字段,但都是char型的
我用的date time picker控件
由用户选择查询时间段进行查询

SELECT * FROM log where (DATEV='2006-11-10' and TIMEV>='00-00-00') or (DATEV>'2006-11-10' and DATEV<'2006-11-11') or (DATEV='2006-11-11' and TIMEV<='11-15-54')这个Sql语句有问题吗

用朋友说用between and 和as,我不大会写,谁帮我写一个看看,谢谢.
另有朋友说合并字段
where (TIMEAA>'2006-11-10 00:00:00') and (TIMEAA<'2006-11-10 23:59:59' )
或者
between...and...
CString sqlStr="SELECT DATEV+timeLong as DATETIMEV from log" ;
合并后又怎么查询呢?是不是要用子查询

[CaiNiaoWuZui]

楼主时间段输入格式是什么？怎么有时是00:00:00，有时是'00-00-00'？
合并：
SELECT * FROM log where (DATEV+TIMEV>='2006-11-10 00:00:00') and (DATEV+TIMEV<='2006-11-10 23:59:59')
between:
SELECT * FROM log where DATEV='2006-11-10' and between(TIMEV,'00:00:00','23:59:59')
楼主写的那个sql，(DATEV='2006-11-10' and TIMEV>='00-00-00')就已经包含了'2006-11-10' 这天所有时间段的记录了，(DATEV>'2006-11-10' and DATEV<'2006-11-11')也是一样，(DATEV='2006-11-11' and TIMEV<='11-15-54') 如果楼主没写错，那它就是包含所有满足(DATEV='2006-11-11' and TIMEV<='11-15-54')的记录

[xiyupiaopiao]

SELECT * FROM log where (DATEV+TIMEV>='2006-11-10 00:00:00') and (DATEV+TIMEV<='2006-11-10 23:59:59')这条语句执行不了啊,是不是DATEV+TIMEV要加括号,
我只是举个例子,实际是要求用户查询某个时间段的记录,如2006-10-18 17:35:00~2006-10-28
21:00:00,这个由用户选择