CREATE FUNCTION USR_TO_DATE(szDT CHAR(8))
RETURNS DATE
SPECIFIC USR_TO_DATE
LANGUAGE SQL
RETURN
SELECT DATE(SUBSTR(szDT,1,4) || '-' ||
SUBSTR(szDT,5,2) || '-' ||
SUBSTR(szDT,7,2))
FROM SYSIBM.SYSDUMMY1;
SELECT USR_TO_DATE(CHAR('20080101')) FROM SYSIBM.SYSDUMMY1;
