RE: DB2 SQL and MAPICS dates

Ugly but it works:
SELECT concat(concat(concat( substr(char(c6aldt),4,2),'/'),       
concat(substr(char(c6aldt),6,2),'/')), substr(char(c6aldt),2,2))  
FROM amflib.MBC6REP                                               

-----Original Message-----
From: Michael J. Dreimiller [mailto:mandis-inc@xxxxxxx] 
Sent: Friday, September 09, 2005 4:44 PM
To: MAPICS-L@xxxxxxxxxxxx
Subject: DB2 SQL and MAPICS dates

9/9/05

I'd appreciate help in converting a MAPICS date (MBC6REP.C6ALDT), which is
in the MAPICS Y2K format (100+YY)MMDD to a format MM/DD/YY using DB2 SQL.

In advance, thanks,

Mike D.
Mandis Inc.
410-526-5996 (O)    410-491-0795 (C)


_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
To post a message email: MAPICS-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/mapics-l.