AW: SQL Problem Coverting from Numeric YYYYMMDD to a Date Format

Date(%editw(MyDate,"0    -  -  ")

... But don't mix RPG with SQL!
(Date is an SQL scalar function, while %EditW is a RPG built-in-function)

My example was pure SQL.
Converting a numeric date into a real date with RPG is much easier:
/Free
   MyDate = %Date(MyNumDate: *ISO);
/End-Free

Converting numbers into dates and dates into numbers is one of the few
features in date calculation that is much easier with native RPG than in
SQL.

It is also possible to write an RPG function to convert the numeric date
into a real date and register this RPG-Function as SQL UDF.
After you can use this RPG Function in SQL like any other scalar function.

Mit freundlichen Gruessen / Best regards

Birgitta

"Shoot for the moon, even if you miss, you'll land among the stars."
(Les Brown)

-----Ursprungliche Nachricht-----
Von: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx]Im Auftrag von Cassidy, Alan
Gesendet: Mittwoch, 19. Juli 2006 19:38
An: RPG programming on the AS400 / iSeries
Betreff: RE: SQL Problem Coverting from Numeric YYYYMMDD to a Date
Format


-----Original Message-----
On Behalf Of HauserSSS
Subject: AW: SQL Problem Coverting from Numeric YYYYMMDD to a Date Format

Building on Birgitta's example,

Date(%editw(MyDate,"0    -  -  ")

Alan

--
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.