AW: Function to display date field as YYYYMM in Sql ?

There is no scalar function in SQL that will show you the date as YYYYMM.
If you want to have one, you have to write it by yourself.

For example:
CREATE FUNCTION MyLib.CvtDateToYYYYMM
      (MYDATE DATE)
         RETURNS CHAR(6)
         LANGUAGE SQL
         SPECIFIC MyLib.CvtDateToYYYYMM
         DETERMINISTIC
         CONTAINS SQL
         CALLED ON NULL INPUT
         NO EXTERNAL ACTION
         NOT FENCED
         RETURN SUBSTR(CHAR(MYDATE, ISO), 1, 4) CONCAT
              SUBSTR(CHAR(MYDATE, ISO), 6, 2)

Birgitta


-----Ursprüngliche Nachricht-----
Von: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx]Im Auftrag von Luqman
Gesendet: Sonntag, 26. Juni 2005 14:20
An: rpg400-l@xxxxxxxxxxxx
Betreff: Function to display date field as YYYYMM in Sql ?


Which function on AS 400 Sql will display date field in YYYYMM Format.

For example:

Date                    YYYYMM (Year, Month)
(dd/mm/yyyy)
01/06/2005          200506
30/09/2005          200509



Best Regards,

Luqman





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