Syntax: ROUND(, []) : ROUND Date « Date Timezone « Oracle PL / SQL






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

Syntax: ROUND(, [])

 
SQL>
SQL>
SQL> SELECT
  2     ROUND(SYSDATE, 'MONTH')  near_month,
  3     SYSDATE    today
  4  FROM DUAL;

NEAR_MONT TODAY
--------- ---------
01-JUL-08 20-JUN-08

SQL>








Related examples in the same category

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