日期查询问题(50分)

Z

zgh777

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-10-17

• #1

我想从一个SQL数据库的表中查询记录，表中有个字段为DateTime类型，按照这个字段来查询，
sqltext := 'select *from sys_log where opertime<='+
DateTimePicker1.Datetime；
上面是错误的，就是按照上面这个意思该怎么写啊(其中opertime是DateTime类型)!

 

Q

qizhao_2001

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-10-17

• #2

:= 'select *from sys_log where opertime<='''+
DateTimePicker1.Datetime+''''；
试试

 

Z

zgh777

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-10-17

• #3

不可以啊，DateTime类型实际是Double类型

 

Z

zdouble

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-10-17

• #4

SELECT * FROM Log WHERE 日期 between #'+st+'# AND #'+et+'#
st,et为string类型如‘2006－01－01’记得加上'#'号

 

一

一只菜鸟Olala

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-10-17

• #5

:=('SELECT * FROM sys_log WHERE opertime<=' + '''' +DateTimePicker1.Datetime+ '''');
看看呢?

 

X

xiammy

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-10-17

• #6

sqltext := 'select *from sys_log where opertime<='+
QuotedStr(DateTimePicker1.Datetime)；

 

Q

qizhao_2001

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-10-17

• #7

'select * from sys_log where opertime<=#'
+ dataToStr(dateTaimePicker1.Datetime) +'#'

 

S

sbamwdx

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-10-17

• #8

晕倒.这种错误都会放啊!!
var
i:integer;
s:string;
begin
s:=i; //这种可以编译过吗???????
动动脑子不就知道了
end;


sqltext := 'select *from sys_log where opertime<='+
DateTimePicker1.Datetime；
应该改为:
sqltext := 'select *from sys_log where opertime<='''+
DateTimeToStr(DateTimePicker1.Datetime)+''''；

 

Z

zgh777

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-10-17

• #9

to zdouble:
sqltext := 'select *from sys_log where opertime<=#'+
datetimetostr(DateTimePicker1.Datetime)+'#'；
这样写对吗？

 

Z

zgh777

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-10-17

• #10

sqltext := 'select *from sys_log where opertime<=#'+
datetimetostr(DateTimePicker1.Datetime)+'#'；
上面运行出错(opertime在数据库是DateTime类型)，有没有人会啊？

 

T

tiger_520

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-10-17

• #11

支持sbamwdx的，就是
sqltext := 'select *from sys_log where opertime<='''+
DateTimeToStr(DateTimePicker1.Datetime)+'''';

 

Z

zgh777

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-10-17

• #12

sqltext := 'select *from allcard where maketime<='+
floattostr(DateTimePicker1.Datetime)；
这样写编译没有问题，但查询结果不正确，为什么 啊？

 

Z

zgh777

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-10-17

• #13

多人接受答案了。