convert 'Apr 19 20:00:03 CDT 2009' string to date

[raj0390]

hi ,

i am unable to convert'Apr 19 20:00:03 CDT 2009' which is a string to a valid date format plz let me know the function

[shash141183]

Try this... but I am not sure whether it will work....
select date('Apr 19 20:00:03 CDT 2009')
from sysibm.sysdummy 1

[docdiesel]

Hi,

that won't do. The string must be in one of the following formats:

• "2009-06-25-16.12.30.000000 "
• "2009-06-25"
• "25-06-2009"

Try to chop and rearrange the string by using substr() and maybe replace() for the month' name.

Regards


Doc