select * from Tablename where datefield >= '2003-09-02' and datefield <= '2003-12-22'
and rundate between to_date('"+ddsj_q+"','yyyy-mm-dd') and to_date('"+ddsj_z+"','yyyy-mm-dd')"
(67) 按时间取记录? 1 用时间段 select * from table where f_date between '2001-1-1 12:00:00' and '2001-1-1 12:10:00' 2 用记录数 select top 600 * from table where f_date > '2001-1-1 12:00:00'
fuzhan820 ddsj_q和ddsj_z是什么意思啊
我的例子: sql.add('select * from 网断报修 where 日期 between'+''''+edit1.text+''''+' and '+''''+edit3.text+'''');
select * from Tablename where datefield >= '2003-9-2 0:0:0' and datefield <= '2003-12-22 23:59:59'
'select * from table where datefield between'+ datetostr(datetimepick1.date)+' and'+ datetostr(datetimepick2.date);
select * from Tablename where datefield between '3-9-2 00:00:00' and '03-12-22 00::00:00'
adoquery.close; adoquery.sql.clear; adoquery.sql.add('select * from table where (datefield>='+ datetostr(datetimepick1.date)+') and (datefield<='+ datetostr(datetimepick2.date)+')'); adoquery.exesql;
Oracle下 select * from TableName where DataField between To_date('2003-1-1','YYYY-MM-DD') and To_date('2003-12-1','YYYY-MM-DD') SQL Server下 select * from TableName where DataField between '2003-1-1' and '2003-12-1'
> Oracle下 > select * from TableName where DataField between To_date('2003-01-01','YYYY-MM-> > > DD') and To_date('2003-12-1','YYYY-MM-DD') > SQL Server下 > select * from TableName where DataField between '2003-01-01' and '2003-12-01'That's right!
这样写好了 ADOQUERY.Close; ADOQUERY.SQL.text := 'select * from Tablename where datefield >= :Date1 and datefield <= :Date2'; ADOQUERY.Parameters.ParamByName('Date1').Value := '2003-01-01'; ADOQUERY.Parameters.ParamByName('Date2').Value := '2003-12-1'; ADOQUERY.Open;
Access:select * from Tablename where datefield between #2003-09-02# and #2003-12-22#或select * from Tablename where datefield between #03-09-02# and #03-12-22#
select * from Tablename where datefield >= cast('2003-09-02' as datetime) and datefield <= cast('2003-12-22' as datetime)
在ACCESS里,日期类型要用“#”括起来 SELECT * FROM PEOPLE WHERE BRITHDAY BETWEEN #1990/1/1# AND #2000/1/1#
ORACLE: 在SQL语句中可以用TO_DATE 也可以用'22-DEC-03'的形式来表示日期,如: SELECT * FROM YOURTABLE WHERE YOURDATEFIELD > '01-JAN-00';
用他的方法应该可以的,你有没有认真去试? 这样很浪费大家时间的.
helodd(可爱) ( ) 信誉:100 2003-09-02 13:03:00 得分:0
'select * from table where datefield between'+ datetostr(datetimepick1.date)+' and'+ datetostr(datetimepick2.date);
darkeye() ( ) 的方法肯定没错了
靠!怎么不行!如下语句在Win2kPro,SQL2K查询分析器中通过编译 use northwind select * from orders where RequiredDate >= '1996-7-5' and RequiredDate <= '1996-8-8'快给我分!!!
select * from Tablename where datefield >= #2003-09-02# and datefield <= #2003-12-22#
select * from Tablename where datefield between '2003-09-02' and '2003-12-22'
哥们,用我的方法吧。这个是正确的。 日期用#2003-09302# and #2003-12-32# 这种来做。
select * from Tablename where datefield between #2003-01-01# and #2003-12-31# ACCESS 要用#号括起来
select * from Tablename where datefield between #2003-01-01# and #2003-12-31# ACCESS
select * from tablename where dates>'2003/01/01' and dates <'2003/12/31'
1 用时间段
select * from table where f_date between '2001-1-1 12:00:00' and '2001-1-1 12:10:00'
2 用记录数
select top 600 * from table where f_date > '2001-1-1 12:00:00'
ddsj_q和ddsj_z是什么意思啊
sql.add('select * from 网断报修 where 日期 between'+''''+edit1.text+''''+' and '+''''+edit3.text+'''');
and '03-12-22 00::00:00'
adoquery.sql.clear;
adoquery.sql.add('select * from table where (datefield>='+ datetostr(datetimepick1.date)+') and (datefield<='+ datetostr(datetimepick2.date)+')');
adoquery.exesql;
select * from TableName where DataField between To_date('2003-1-1','YYYY-MM-DD') and To_date('2003-12-1','YYYY-MM-DD')
SQL Server下
select * from TableName where DataField between '2003-1-1' and '2003-12-1'
> select * from TableName where DataField between To_date('2003-01-01','YYYY-MM-> > > DD') and To_date('2003-12-1','YYYY-MM-DD')
> SQL Server下
> select * from TableName where DataField between '2003-01-01' and '2003-12-01'That's right!
ADOQUERY.Close;
ADOQUERY.SQL.text := 'select * from Tablename where datefield >= :Date1 and datefield <= :Date2';
ADOQUERY.Parameters.ParamByName('Date1').Value := '2003-01-01';
ADOQUERY.Parameters.ParamByName('Date2').Value := '2003-12-1';
ADOQUERY.Open;
SELECT * FROM PEOPLE
WHERE BRITHDAY BETWEEN #1990/1/1# AND #2000/1/1#
在SQL语句中可以用TO_DATE
也可以用'22-DEC-03'的形式来表示日期,如:
SELECT * FROM YOURTABLE WHERE YOURDATEFIELD > '01-JAN-00';
helodd(可爱) ( ) 信誉:100 2003-09-02 13:03:00 得分:0
'select * from table where datefield between'+ datetostr(datetimepick1.date)+' and'+ datetostr(datetimepick2.date);
的方法肯定没错了
use northwind
select * from orders where RequiredDate >= '1996-7-5' and RequiredDate <= '1996-8-8'快给我分!!!
日期用#2003-09302# and #2003-12-32#
这种来做。
ACCESS 要用#号括起来
ACCESS