求一条多个条件的SQL语句

[sky_1989]

select * from PREPAREMEETING where (STARTDATE>=to_date('2009-07-29','YYYY-MM-DD') and STARTDATE<=to_date('2009-08-11','YYYY-MM-DD'))
or (ENDDATE>=to_date('2009-07-29,'YYYY-MM-DD') and ENDDATE<=to_date('2009-08-11','YYYY-MM-DD') )
or (STARTDATE<=to_date('2009-07-29,'YYYY-MM-DD') and ENDDATE>=to_date('2009-08-11','YYYY-MM-DD'))
SQL语句不支持这样写
求高手解决！！

[jinjazz]

你这是oracle语法，sql直接STARTDATE>='2009-07-29'这样

[黄_瓜]

to_date

[feixianxxx]

select * from PREPAREMEETING 
where (STARTDATE between '2009-07-29'and '2009-08-11') 
      or (ENDDATE between'2009-07-29' and '2009-08-11' ) 
      or (STARTDATE <='2009-07-29' and ENDDATE>='2009-08-11') 

[feixianxxx]

--or

select * from PREPAREMEETING 
where (convert(varchar(10),STARTDATE,120) between '2009-07-29'and '2009-08-11') 
      or (convert(varchar(10),ENDDATE,120)  between'2009-07-29' and '2009-08-11' ) 
      or (convert(varchar(10),STARTDATE,120)  <='2009-07-29' and convert(varchar(10),ENDDATE,120)>='2009-08-11') 

[sdhdy]

select * from PREPAREMEETING where (STARTDATE>='2009-07-29'and STARTDATE <='2009-08-11')
      or (ENDDATE>='2009-07-29' and ENDDATE <='2009-08-11') 
      or (STARTDATE <='2009-07-29' and ENDDATE>='2009-08-11') 

[SQL77]

select * from PREPAREMEETING where (STARTDATE>=to_date('2009-07-29','YYYY-MM-DD') and STARTDATE <=to_date('2009-08-11','YYYY-MM-DD'))
or (ENDDATE>=to_date('2009-07-29','YYYY-MM-DD') and ENDDATE <=to_date('2009-08-11','YYYY-MM-DD') )
or (STARTDATE <=to_date('2009-07-29','YYYY-MM-DD') and ENDDATE>=to_date('2009-08-11','YYYY-MM-DD'))
楼主少了几个标点符号

[feixianxxx]

--又或者

select * from PREPAREMEETING 
where (datediff(dd,'2009-07-29',STARTDATE)>=0 and datediff(dd,'2009-08-11',STARTDATE)<=0) 
      or (datediff(dd,'2009-07-29',ENDDATE)>=0   and datediff(dd,'2009-08-11' ,ENDDATE)<=0 ) 
      or (datediff(dd,'2009-07-29',STARTDATE)<=0 and  datediff(dd,'2009-08-11' ,ENDDATE)>=0) 

[SQL77]

[Quote=引用楼主 sky_1989 的回复:]
select * from PREPAREMEETING where (STARTDATE>=to_date('2009-07-29','YYYY-MM-DD') and STARTDATE <=to_date('2009-08-11','YYYY-MM-DD'))
      or (ENDDATE>=to_date('2009-07-29,'YYYY-MM-DD') and ENDDATE <=to_date('2009-08-11','YYYY-MM-DD') )
      or (STARTDATE <=to_date('2009-07-29,'YYYY-MM-DD') and ENDDATE>=to_date('2009-08-11','YYYY-MM-DD'))
SQL语句不支持这样写
求高手解决！！
[/Quote]
晕了还得用SQL呀,参考楼上

[souperstar]

[Quote=引用 2 楼 jinjazz 的回复:]
你这是oracle语法，sql直接STARTDATE>='2009-07-29'这样
[/Quote]
up~~

[sky_1989]

谢谢7楼
呵呵，果然是写的时候不小心
本来就是用oracle

[feixianxxx]

[Quote=引用 11 楼 sky_1989 的回复:]
谢谢7楼
呵呵，果然是写的时候不小心
本来就是用oracle
[/Quote]
.......

[feixianxxx]

to_date这个函数干嘛的？