RE: SQL - Cast Numeric to Date

Michael, 

Something like this should give you DATE data type:

SELECT DATE(SUBSTR(F1,1,4)        CONCAT '-' 
            CONCAT SUBSTR(F1,5,2) CONCAT '-' 
            CONCAT SUBSTR(F1,7,2)) 
       AS MyDate                              
FROM QTEMP/T1 

If you want it displayed using ISO, either make sure your job runs in ISO
format or cast date back to char using ISO specifier:

SELECT CHAR(DATE(SUBSTR(F1,1,4)        CONCAT '-' 
                 CONCAT SUBSTR(F1,5,2) CONCAT '-' 
                 CONCAT SUBSTR(F1,7,2)), ISO) 
       AS MyDate
FROM QTEMP/T1

Elvis

-----Original Message-----
Subject: SQL - Cast Numeric to Date

I have an 8.0 field in a file. I want to do something like this:

Select Date(Num_Field) as Mydate...

I can see how to do it with a CAST on a character field - what do I need
to do for a numeric field in CCYYMMDD format? It's not really ISO...at
least I can't see how to specify no seperators.

Thanks...