Re: UDF - returning date format question was( SQL question - why doesn't WHERE clause know about renamed fields?)

Do a F13 in STRSQL and you will see that the output format is set to MDY.
Change to ISO and you will see the dates in ISO format.

On Mon, Nov 8, 2010 at 11:24 AM, Gqcy<gmufasa01@xxxxxxxxx> wrote:

OOPS,
My question should be:
WHY does the dates in green screen (STRSQL) show as "MM/DD/YY"???
( I ran the same query in System i nav. and I got ISO dates...)


On 11/8/2010 12:14 PM, Gqcy wrote:

here is my UDF code.
My dates return as "MM/DD/YY".
What Do I need to put in to have them return as ISO ("YYYY-MM-DD")?


CREATE FUNCTION XYZLIB/NUMTODATE (INNUM DEC(8))
RETURNS DATE
LANGUAGE SQL
CONTAINS SQL
EXTERNAL ACTION
DETERMINISTIC
BEGIN
DECLARE RTDATE DATE;
SET RTDATE = Date(Substr(Digits(INNUM), 1, 4) concat '-' concat
Substr(Digits(INNUM), 5, 2) concat '-' concat
Substr(Digits(INNUM), 7, 2)) ;
RETURN RTDATE;
END

Thanks so much...