ROUND : Date Functions « PL SQL Data Types « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. PL SQL Data Types
  3. Date Functions

ROUND, typically applied to numbers, also work with dates and timestamps.

ROUND rounds the date to a specified point.

v_dt:= ROUND (DATE|TIMESTAMP|INTERVAL value[,PRECISION]);

Rather than numeric precision, here you use date format masks.

For example, 'YYYY' truncates the date to years, and 'MM' to a month.

If you don't specify any precision, the default is day ('DD').

You can't specify a combination of format masks.

Only one can be specified at a time.

SQL> declare
  2      v_dt DATE;
  3      v_form_tx VARCHAR2(25):='YYYY-MM-DD HH24:MI:SS';
  4  begin
  5      v_dt:=round(sysdate,'HH');
  6      DBMS_OUTPUT.put_line(to_char(v_dt,v_form_tx));
  7  end;
  8  /
2007-06-09 21:00:00

PL/SQL procedure successfully completed.

SQL>








21.10.Date Functions
21.10.1.Working with dates and built-in functions EXTRACT
21.10.2.TRUNC and ROUND
21.10.3.ROUND
21.10.4.ADD_MONTHS
21.10.5.LAST_DAY
21.10.6.MONTHS_BETWEEN
21.10.7.Use TRUNC to get only the time
21.10.8.Returning a point just before a specific midnight with TRUNC
21.10.9.TO_DATE('29-DEC-1988','dd-mon-yyyy')