Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     DB2 Date Extraction Question.....
Go
New
Search
Notify
Tools
Reply
  
DB2 Date Extraction Question.....
 Login/Join
 
Member
posted
Could someone point me to the documentation that will help me extract the year from a DB2 'DATE'? (Focus 7.2.6 - MVS)

The date is defined as:

RI_BEGIN_DATE DATE NOT NULL,
RI-BEGIN-DATE PIC X(10).

I want to use only the year from the above field. I thought I had done this before, but just can't find my example.

Thanks,
Jackie
 
Posts: 19 | Location: Little Rock, AR | Registered: July 21, 2003Reply With QuoteReport This Post
Expert
posted Hide Post
Jackie,

What is the definition in your .mas file?

If it is YYMD, or the like, then you should be able to use the year within a define or display by specifying -

PRINT RI_BEGIN_DATE/YY

for the full four digit year

Depending on other actual and usage formats in you .mas there will be other solutions.
 
Posts: 5601 | Location: United Kingdom | Registered: April 08, 2004Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     DB2 Date Extraction Question.....

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.