oracleÈÕÆÚÀàÐÍÎÊÌâ

oracleÈÕÆÚÀàÐÍ×Ö¶ÎÊDz»ÊDz»ÄÜ´æ´¢2009-01 ÕâÑùÀàÐ͵Ä×ֶΰ¡£¿Ò²¾ÍÊÇ˵ֻµ½Ô·ݣ¬Ð»ÁË°¡

---

ºÃÏñ²»ÄÜ¡£Ö»Äܴ洢ΪvarcharÀàÐÍ to_char(sysdate,'yyyy-mm')

---

ÒýÓÃ

ºÃÏñ²»ÄÜ¡£Ö»Äܴ洢ΪvarcharÀàÐÍ to_char(sysdate,'yyyy-mm')

Õý½â

---

ÒýÓà 1 Â¥ vber1010 µÄ»Ø¸´:
ºÃÏñ²»ÄÜ¡£Ö»Äܴ洢ΪvarcharÀàÐÍ to_char(sysdate,'yyyy-mm')

---

¿ÉÒÔ°¡,ÄãÈÕÆÚµÄÈÕËæ±ãÌîд°¡,·´ÕýÄãÈ¡³öÀ´µÄʱºòÓÖ²»ÓÃ

---

SQL code:

drop table test_date;
create table test_date(
test_date date
);
insert into test_date
select to_date('2010-1','yyyy-mm') from dual union all
select to_date('2010-1','yyyy-mm') from dual union all
select to_date('2010-1','yyyy-mm') from dual;

select * from test_date;

--½á¹û
/*
2010-1-1
2010-1-1
2010-1-1
*/