求救！SQL语句，十万火急！

黑骏马

请问我要用ISQL删除一个数据库，里面前10天的记录，用DELETE该怎么删除？
环境：SCO UNIX、INFORMIX

我用这个命令不得行：delete from where date="2006/10/01-2006/10/10"

wenlq

delete from tab where datecol between '11/10/2006'  -10 and '11/10/2006'

黑骏马

楼上的老兄：我想请你给我说，下载或看这方面资料的网址！万分感谢，主要是在单位才接触！
谢谢！十分感谢！

wenlq

http://www-306.ibm.com/software/ ... ibrary/list4.html#S

黑骏马

谢谢,光明使者,有没有中文呀,俺英文不好!
万分感谢!

wenlq

Simplified Chinese IBM Informix Dynamic Server Performance Guide, Version 10.0 (G151-0128-00)
Simplified Chinese IBM Informix Dynamic Server Performance Guide, Version 9.4 (G152-0562-00)
Simplified Chinese IBM Informix GLS User's Guide, Version 10.0 (G151-0120-00)
Simplified Chinese IBM Informix GLS User's Guide, Version 9.4/8.4 (G152-0554-00)
Simplified Chinese IBM Informix Guide to SQL: Reference, Version 10.0 (G151-0121-00)
Simplified Chinese IBM Informix Guide to SQL: Reference, Version 9.4 (G152-0556-00)
Simplified Chinese IBM Informix Guide to SQL: Syntax, Version 10.0 (G151-0122-00)
Simplified Chinese IBM Informix Guide to SQL: Syntax, Version 9.4 (G152-0558-00)
Simplified Chinese IBM Informix Guide to SQL: Tutorial, Version 10.0 (G151-0123-00)
Simplified Chinese IBM Informix Guide to SQL: Tutorial, Version 9.4 (G152-0557-00)
Simplified Chinese IBM Informix High-Performance Loader User's Guide, Version 10.0 (G151-0124-00)
Simplified Chinese IBM Informix High-Performance Loader User's Guide, Version 9.4 (G152-0560-00)
Simplified Chinese IBM Informix Migration Guide, Version 10.0 (G151-0127-00)
Simplified Chinese IBM Informix Migration Guide, Version 9.4 (G152-0552-00)
Simplified Chinese IBM Informix Storage Manager Administrator's Guide, Version 10.0 (G151-0129-00)
Simplified Chinese IBM Informix Storage Manager Administrator's Guide, Version 9.4 (G152-0569-00)
Simplified Chinese IBM Informix User-Defined Routines and Data Types Developer's Guide, Version 10.0 (G151-0130-00)
Simplified Chinese IBM Informix User-Defined Routines and Data Types Developer's Guide, Version 9.4 (G152-0563-00)

sqlnet

select jgm,jym,jyje,ye from flsmxz
      where jyrq between '10/20/2006' -10 and '10/20/2006'
1213: Character to numeric conversion error

select jgm,jym,jyje,ye from flsmxz
      where jyrq between '20061020' -10 and '20061020'
1210: Date could not be converted to month/day/year format