No one can answer this question

[raj0390]

How to convert 'Apr 19 20:00:03 CDT 2009' text to date using db2 functions

[vkesavdba]

Did you solved mystery?

http://www.ibm.com/developerworks/db.../0211yip3.html

check this it may help

[Kozy]

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