I don't know specifically about the "territory code" (never worked on little DB2) but it sounds like the parameters ".

DB2 SQL can format dates & times in several different formats

try running the following to see what I mean:
SELECT CURRENT DATE AS "DEFAULT FORMAT"
,CHAR(CURRENT DATE,ISO) AS "ISO FORMAT"
,CHAR(CURRENT DATE,USA) AS "U.S.A. FORMAT"
,CHAR(CURRENT DATE,EUR) AS "EUROPEAN "
FROM SYSIBM.SYSDUMMY1;

Then substitute TIME for DATE and run it again.

Here is sample SQL to do even more things with DATE (& TIME)

SELECT YEAR(date_col) YYYY, DAYOFYEAR(date_col) JJJ

SELECT
CASE MONTH(CURRENT DATE)
WHEN 1 THEN 'JANUARY '
WHEN 2 THEN 'FEBRUARY '
WHEN 3 THEN 'MARCH '
WHEN 4 THEN 'APRIL '
WHEN 5 THEN 'MAY '
WHEN 6 THEN 'JUNE '
WHEN 7 THEN 'JULY '
WHEN 8 THEN 'AUGUST '
WHEN 9 THEN 'SEPTEMBER '
WHEN 10 THEN 'OCTOBER '
WHEN 11 THEN 'NOVEMBER '
WHEN 12 THEN 'DECEMBER '
END

Good luck

meandyou

Please complete the following information:

REGISTER / LOG-IN TO DISCUSS

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Submit your e-mail address below to continue

E-mail: 

E-mail: 

Handle:   

Password: 

Forgot Password?

Create Handle: 

Your handle identifies you in ITKnowledgeExchange. Max 30 char.

Create Password: 

Confirm Password: 

Yes, I agree to the IT Knowledge Exchange  Terms and Conditions.

hidden modal window