| Newbie | | Join Date: Jun 2009
Posts: 3
| |
| re: No one can answer this question
Or just write a simpl function... exampl of sql ( might have done something wrong in the month names, so check that, jan, feb, mar ... dec ), other then that this should work. -
SELECT
-
TRIM(SUBSTR(T1.DATE_CONVERT,LOCATE(' ',T1.DATE_CONVERT),LOCATE(' ',SUBSTR(T1.DATE_CONVERT,LOCATE(' ',T1.DATE_CONVERT)))+2))||'.'||CASE WHEN SUBSTR(T1.DATE_CONVERT,1,3) = 'JAN' THEN '1' WHEN SUBSTR(T1.DATE_CONVERT,1,3) = 'FEB' THEN '2' WHEN SUBSTR(T1.DATE_CONVERT,1,3) = 'MAR' THEN '3' WHEN SUBSTR(T1.DATE_CONVERT,1,3) = 'APR' THEN '4' WHEN SUBSTR(T1.DATE_CONVERT,1,3) = 'MAY' THEN '5' WHEN SUBSTR(T1.DATE_CONVERT,1,3) = 'JUN' THEN '6' WHEN SUBSTR(T1.DATE_CONVERT,1,3) = 'JUL' THEN '7' WHEN SUBSTR(T1.DATE_CONVERT,1,3) = 'AUG' THEN '8' WHEN SUBSTR(T1.DATE_CONVERT,1,3) = 'SEP' THEN '9' WHEN SUBSTR(T1.DATE_CONVERT,1,3) = 'OKT' THEN '10' WHEN SUBSTR(T1.DATE_CONVERT,1,3) = 'NOV' THEN '11' WHEN SUBSTR(T1.DATE_CONVERT,1,3) = 'DEC' THEN '12' ELSE '1' END||'.'||TRIM(SUBSTR(T1.DATE_CONVERT,LENGTH(T1.DATE_CONVERT)-3,4))
-
FROM (SELECT UPPER('MAY 1 20:00:03 CDT 2009') AS DATE_CONVERT FROM SYSIBM.SYSDUMMY1)
-
AS T1
-
|
