数据库版本:10.2.0.1.0
表结构如下:
create table "ADMIN"."V_SELLVIEW"(
"SELLID" VARCHAR2(30) not null,
"SPNAME" VARCHAR2(50) not null,
"SPID" VARCHAR2(50) not null,
"GG" VARCHAR2(50) not null,
"DJ" NUMBER not null,
"SL" FLOAT(126) not null,
"JE" FLOAT(126),
"KHNAME" VARCHAR2(100) not null,
"XSDATE" TIMESTAMP(6) not null,
"CZY" VARCHAR2(30) not null,
"JSR" VARCHAR2(30) not null,
"JSFS" VARCHAR2(10) not null
);
select * from v_sellView
where khname = '222'
and xsdate>'2009-01-01'
and xsdate<='2009-06-22 23:59:59'语句提示 not a valid month
但是只执行其中的任何一句 and 都没问题 请 指点
表结构如下:
create table "ADMIN"."V_SELLVIEW"(
"SELLID" VARCHAR2(30) not null,
"SPNAME" VARCHAR2(50) not null,
"SPID" VARCHAR2(50) not null,
"GG" VARCHAR2(50) not null,
"DJ" NUMBER not null,
"SL" FLOAT(126) not null,
"JE" FLOAT(126),
"KHNAME" VARCHAR2(100) not null,
"XSDATE" TIMESTAMP(6) not null,
"CZY" VARCHAR2(30) not null,
"JSR" VARCHAR2(30) not null,
"JSFS" VARCHAR2(10) not null
);
select * from v_sellView
where khname = '222'
and xsdate>'2009-01-01'
and xsdate<='2009-06-22 23:59:59'语句提示 not a valid month
但是只执行其中的任何一句 and 都没问题 请 指点
where khname = '222'
and xsdate>to_date('2009-01-01','yyyy-mm-dd')
and xsdate <=to_date('2009-06-22 23:59:59','yyyy-mm-dd hh24:mi:ss')
用to_date转换一下,你的date格式和以上不一致造成的错误,用to_date转一下最好。