SQL Date Formatting Issue

["Fred Horvat" <horvat@xxxxxxxx>]

Hello,

I am working with a query tool and am having trouble formatting a field as a
date in a SQL Select statement.  Here's what is going on.  I have two files
from the iSeries.  One has a date field that is defined as numeric 6.0 and
in YYMMDD format.  The following code will output the date as MM/DD/YYYY

DATE(SUBSTR(DIGITS(OHETDT),3,2) CONCAT '/' CONCAT
	SUBSTR(DIGITS(OHETDT),5,2) CONCAT '/' CONCAT
	SUBSTR(DIGITS(OHETDT),1,2)) AS ENTRY_DATE



Another file I am working with has a date field that is defined as variable
V50 as bbYYYYMMDD.  The following code gives me blank output.  

DATE(SUBSTR(DIGITS(SHIP_DATE),7,2) CONCAT '/' CONCAT
	SUBSTR(DIGITS(SHIP_DATE),9,2) CONCAT '/' CONCAT
	SUBSTR(DIGITS(SHIP_DATE),5,2)) AS DATE_SHIPPED


I believe I have the positions line up properly as the date doesn't actually
start until position 3 in the field.  Are variable length fields handled
differently in SQL for what I am trying to do?






Fred Horvat
horvat@xxxxxxxx
216-426-5692