hello all,

i have a string 'Apr 19 20:00:03 CDT 2009' which i need to convert in to date does DB2 have any function to do it?

raj0390, It would help if you list the DB2 and version (along with operating system) so the appropriate answer can be supplied (i.e. some functions are in DB2 z/OS but not LUW).

However, I don't believe any DB2 has a function to convert that string into a Timestamp. At least not directly.

If you format is identical in all cases, you can try to parse out the information and build a timestamp string. For example

SUBSTR('TS-STRING',21,4) || '-' || CASE SUBSTR('TS-STRING',1,3) WHEN 'Jan' THEN '01'
WHEN 'Feb' THEN 02
etc.
end
|| '-' || SUBSR(you get the idea I hope).

PS TS-STRING is the character timestamp string you have in your post. I didn't want to type all that in the example.

You should also tell us whether you need a timestamp or a date value.

i just need the date value

thx mate, for your time