select round( sysdate, 'year' ) : ROUND Date « Date Timezone « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Date Timezone
  3. ROUND Date

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> --








Related examples in the same category

1.Syntax: ROUND(, [])
2.Rounding to the nearest minute
3.ROUND: Round a date to a particular month or year
4.select round( sysdate )
5.select round( sysdate, 'month' )
6.select round( sysdate, 'q' ) "Quarter"