RE: Need help on SQLRPGLE

Use the SQL Date() function to convert the numeric field to a date
field. From there it's a no-brainer. 


Thanks,
S. Ellsberry
(678) 893-6673
steve.ellsberry@xxxxxxxxxxxx
 

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of sanjib
Sent: Thursday, November 30, 2006 7: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.
--
Regards,
Sanjib
--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing
list To post a message email: RPG400-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/rpg400-l.