Oracle中的日期在sql中如何写？(100分)

南

南宫慕容

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-12-06

• #1

delphi5/Oracle7
在查询时，如果有一字段：riqi是日期型的
sql语句这样写：
with adoquery1 do
begin
close;
sql.clear;
sql.add('select * from table where riqi=''1980-01-01'''');
open;
active:=true;
end;
不能执行，现在想知道如果想查询确切的日期，该怎么写sql语句？

 

D

dongberlin

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-12-06

• #2

select * from table where riqi=todate(''1980-01-01'', ''YYYY-MM-DD'')'
sql.add('select * from table where riqi=todate(''1980-01-01'', ''YYYY-MM-DD'')');

 

Y

yzhshi

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-12-06

• #3

to_date('日期','yyyy-mm-dd hh:mi:ss')

 

C

cto-wind

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-12-06

• #4

to:dongberlin, yzhshi
应该是这样：to_date 而不是todate
select * from tab where date = to_date('1980-01-01', 'YYYY-MM-DD')

 

D

dongberlin

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-12-06

• #5

to:cto-wind
你是对的,我写错了.
sql.add('select * from table where riqi=to_date(''1980-01-01'', ''YYYY-MM-DD'')');

 

Z

zhanggm

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-12-06

• #6

with Query do
begin
Close;
SQL.Clear;
SQL.Add('select * from tab where date = :mydate');
ParamByName('mydate'').AsDateTime:=StrToDateTime('1980-01-01');
Open;
end;

 

D

datm

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-12-07

• #7

mm-dd-yyyy
月份要用英语,eg dec,oct

 

南

南宫慕容

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-12-07

• #8

问题已经解决！多谢cto-wind和dongberlin的大力帮助！谢谢