Robert Sample
Global Moderator
Joined: 06 Jun 2008 Posts: 8696 Location: Dubuque, Iowa, USA
|
|
|
|
This looks like SAS more than DB2. In SAS you need to do:
Code: |
NEWDATE = INPUT(OLDDATE,YYMMDD8.) ;
FORMAT NEWDATE YYMMDDD10.;
|
SAS dates are internally stored as integers, so you merely have to tell it which format to use. |
|