RE: DB2 SQL and MAPICS dates

Lisa, thanks, works perfectly!!
--
Best regards, 

Mike Dreimiller 
Mandis Inc. 
410-526-5996 
Mandis-Inc@xxxxxxx


-------------- Original message from Lisa.Thomas@xxxxxxxxxxx: -------------- 


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