sql中怎么找出日期时间记录(在线急等)
sql中如何找出日期时间记录(在线急等)
我数据库用oracle9i
select rwh,cx,vin,sxrq from ZZP_ZPJHTZ
sxrq查询结果为:2007-6-14 18:39:14
我用delphi查不到它
sql.text:= 'select rwh,cx,vin,sxrq
from ZZP_ZPJHTZ
where sxrq = to_date( ' ' '+Label2.Caption+ ' ' ', ' 'YYYY-MM-DD ' ') ';
又没办法呀???
------解决方案--------------------
create table t3 (ctime date);
insert into t3
select to_date( '2003-03-03 11:11:11 ', 'yyyy-mm-dd HH24:MI:SS ') from dual;
--执行查询
select * from t3 where ctime=to_date( '2003-03-03 11:11:11 ', 'yyyy-mm-dd HH24:MI:SS ');
--查询结果
2003-3-3 11:11:11
我数据库用oracle9i
select rwh,cx,vin,sxrq from ZZP_ZPJHTZ
sxrq查询结果为:2007-6-14 18:39:14
我用delphi查不到它
sql.text:= 'select rwh,cx,vin,sxrq
from ZZP_ZPJHTZ
where sxrq = to_date( ' ' '+Label2.Caption+ ' ' ', ' 'YYYY-MM-DD ' ') ';
又没办法呀???
------解决方案--------------------
create table t3 (ctime date);
insert into t3
select to_date( '2003-03-03 11:11:11 ', 'yyyy-mm-dd HH24:MI:SS ') from dual;
--执行查询
select * from t3 where ctime=to_date( '2003-03-03 11:11:11 ', 'yyyy-mm-dd HH24:MI:SS ');
--查询结果
2003-3-3 11:11:11