如果你定义成DATE型,就是你存储的时候写入的是年月,但是保存在数据库里的时候会自动加上日期。因为你保存的时候必须用to_date来转换,而这个函数会自动加上日期:
create table test(dt date);
insert into test values (to_date('2014/01','yyyy/mm'));
insert into test values (to_date('2014/08','yyyy/mm'));
select * from test;select to_date('2014/01','yyyy/mm') from dual;
create table test(dt date);
insert into test values (to_date('2014/01','yyyy/mm'));
insert into test values (to_date('2014/08','yyyy/mm'));
select * from test;select to_date('2014/01','yyyy/mm') from dual;
create table test(dt date);
insert into test values (to_date('2014/01','yyyy/mm'));
insert into test values (to_date('2014/08','yyyy/mm'));
select * from test;select to_date('2014/01','yyyy/mm') from dual;
恩,谢谢
create table test(dt date);
insert into test values (to_date('2014/01','yyyy/mm'));
insert into test values (to_date('2014/08','yyyy/mm'));
select * from test;select to_date('2014/01','yyyy/mm') from dual;
恩,谢谢
如果问题解决请结贴