日期(100分)

G

ggbb

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2000-01-31

• #1

DELPHI 如何在动态SQL语句中使用日期型参数。

 

F

Fencer

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2000-01-31

• #2

这得看你用的数据库
在DB2中可以直接用字符串，
在Oracle中可以用ToDate函数。

 

C

CJ

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2000-01-31

• #3

QUERY.CLOSE;
QUERY.SQL.CLEAR;
QUERY.SQL.ADD('SELECT * FROM YOURTABLE WHERE YOURDATE > 1');
QUERY.PARAMENTERS[0].VALUE := NOW;
QUERY.PERPARE;
QUERY.OPEN;

 

G

g622

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2000-01-31

• #4

d5下：


QUERY1.CLOSE;
QUERY1.SQL.CLEAR;
QUERY1.SQL.ADD('SELECT * FROM YOURTABLE WHERE YOURDATE > :d1 or YOURDATE > :d2 ');
Query1.Params[0].AsTime := StrToTime(yourvaluestr1);
Query1.Params[1].AsDateTime := StrToDateTime(yourvaluestr2);
QUERY1.OPEN;

 

J

Jams

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2000-01-31

• #5

>>

 

J

Jack1

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2000-02-01

• #6

你不妨试一试#，很有用的！

 

Y

youtoo

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2000-02-01

• #7

不同数据库产品的日期数据类型会有不同,自己查一查相关的数据库操作手册

 

3

3h

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2000-02-01

• #8

直接用'2000-02-01 01:00:00:0000'可以吧。

 

W

wrench

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2000-02-01

• #9

QUERY.CLOSE;
QUERY.SQL.CLEAR;
QUERY.SQL.ADD('SELECT * FROM YOURTABLE WHERE YOURDATE > 1');
QUERY.PARAMBYNAME('D1').ASDATETIME := NOW;
QUERY.PERPARE;
QUERY.OPEN;

或者

QUERY.CLOSE;
QUERY.SQL.CLEAR;
QUERY.SQL.ADD('SELECT * FROM YOURTABLE WHERE YOURDATE > 1');
QUERY.PARAMBYNAME('D1').ASSTRING := '2000-1-1 12:00:00';
QUERY.PERPARE;
QUERY.OPEN;

均可

 

H

hsw

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2000-02-02

• #10

G

 

林

林海

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2000-02-02

• #11

对PARADOX
SQL.Text:='Select * From "Table.DB" Where YourParam=:???'
设参数类型为Date.
ParamByName('...').asDate:=Now;
对ACCESS
SQL.Text:='Select * From "Table.DB"
Where DateField=DateValuep_StartDate)'
参数类型为String.
PAramsByName('..').asString:=Format('mm/dd/yyyy',Date);

 

国

国忧

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2000-02-10

• #12

x

 

L

Liuz

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2000-02-11

• #13

in MSSQL server, u can use a build-in function called "Convert" that
convert a string to datetime. more info in SQL on-line book.

 

S

spear

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2000-02-14

• #14

可用各个数据库内建的日期函数

 

G

ggbb

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2000-02-17

• #15

多人接受答案了。