RE: Need help on SQLRPGLE

["DeLong, Eric" <EDeLong@xxxxxxxxxxxxxxx>]

You need to convert the numeric date into a character string, then piece the 
parts together to make a character date value compatible with your SQL date 
format default.  Here's a piece of a select I used recently...

SELECT SUBSTR(DIGITS(C.CRDATE),1,4)||'-'|| 
       SUBSTR(DIGITS(C.CRDATE),5,2)||'-'|| 
       SUBSTR(DIGITS(C.CRDATE),7,2)        

This takes a decimal value in YYYYMMDD format and converts it to 'YYYY-MM-DD'.  
This converted value can be used in your SQL expression as a date value.

hth,
Eric

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx]On Behalf Of sanjib
Sent: Thursday, November 30, 2006 6:02 AM
To: RPG400-L@xxxxxxxxxxxx
Subject: Need help on SQLRPGLE


Hi List,
There is a file having field XYZDAT( Numeric type, size 8,YYYYMMDD). This
field is used to hold the Invoice date but its data type is numeric.I would
like to make a date difference between Current date Curdate( ) and XYZDAT. I
need to change the data type numeric to Date type.Any idea regarding the
conversion of  data type from Numeric to Date type ? would b grat if i can
make it in a single SQL statement.
Thanks in advance.