DPART: Extracting a Component From a Date Field

How to:

The DPART function extracts a specified component from a date field and returns it in numeric format.

Available Languages: reporting, Maintain
Top of page
x
Syntax: How to Extract a Date Component and Return It in Integer Format
DPART (datevalue, 'component', outfield)

where:

datevalue

Date

Is a full component date.

component

Alphanumeric

Is the name of the component to be retrieved enclosed in single quotation marks. Valid values are:

For year: YEAR, YY

For month: MONTH, MM

For day: DAY, For day of month: DAY-OF-MONTHDD.

For quarter: QUARTER, QQ

outfield

Integer

Is the field that contains the result, or the integer format of the output value enclosed in single quotation marks.
Example: Extracting Date Components in Integer Format

The following request against the VIDEOTRK data source uses the DPART function to extract the year, month, and day component from the TRANSDATE field:

DEFINE FILE
 VIDEOTRK                       
 YEAR/I4 = DPART(TRANSDATE, 'YEAR', 'I11');
 MONTH/I4 = DPART(TRANSDATE, 'MM', 'I11'); 
 DAY/I4 = DPART(TRANSDATE, 'DAY', 'I11');  
END                                        
                                           
TABLE FILE VIDEOTRK                        
PRINT TRANSDATE YEAR MONTH DAY             
BY LASTNAME BY FIRSTNAME                   
WHERE LASTNAME LT 'DIAZ'                   
END

The output is:

LASTNAME         FIRSTNAME   TRANSDATE  YEAR  MONTH   DAY
--------         ---------   ---------  ----  -----   ---
ANDREWS          NATALIA     91/06/19   1991      6    19
                             91/06/18   1991      6    18
BAKER            MARIE       91/06/19   1991      6    19
                             91/06/17   1991      6    17
BERTAL           MARCIA      91/06/23   1991      6    23
                             91/06/18   1991      6    18
CHANG            ROBERT      91/06/28   1991      6    28
                             91/06/27   1991      6    27
                             91/06/26   1991      6    26
COLE             ALLISON     91/06/24   1991      6    24
                             91/06/23   1991      6    23
CRUZ             IVY         91/06/27   1991      6    27
DAVIS            JASON       91/06/24   1991      6    24
WebFOCUS