TRUNC(), ROUND() Format
http://www.java2s.com/Code/Oracle/Date-Timezone/formatsusedwiththeTRUNCfunctionfortheDATEdatatype.htm Format Element Description Example CC One greater than the first two digits of a four-digit year. ROUND(SYSDATE,'CC') SCC One greater than the first two digits of a four-digit year. ROUND(SYSDATE,'SCC') Year SYYYY Year; rounds up on July 1. ROUND(SYSDATE,'SYYYY') YYYY Year; rounds up on July 1. ..
2009.05.15