ROUND Date « Date Timezone « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Date Timezone
  3. ROUND Date
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, 'year' )
6.select round( sysdate, 'month' )
7.select round( sysdate, 'q' ) "Quarter"