oracle trunc()取日期
oracle trunc()取日期假设当前日期是 2007-9-19 ,想取当前系统时间,只要日期,不要时分秒,则参照如下:select trunc(sysdate ,'dd') from dual ; -- 2007-9-19select trunc(sysdate ,'yyyy') from dual ; --2007-1-1select trunc(sysdate ,'mm') from dual ; --2007-9-1insert into emp(birthday) values(trunc(sysdate ,'dd'));