Mega Code Archive
Categories
/
Oracle PLSQL
/
Date Timezone
Select round( sysdate, year )
SQL> SQL> select round( sysdate, 'year' ) 2 from dual 3 / ROUND(SYS --------- 01-JAN-08 1 row selected. SQL> SQL> SQL> --