Hi All,

I would like to convert a date in char type with the format 'dd/mm/yyyy' (eg. 30/01/2006) into date datatype before inserting into the table.

instead of substring the char into day, month and year, Is there any faster way to do that?

Thank you very much.

can this not be used ?
TO_DATE--(--string-expression--,format-string--)----

Hi,

You can convert date to character using te function to_char.

Example: to_char(sysdate, 'DD-MON-YYYY') will return the date in ther format DD-MON-YYYY like 01-JAN-2006.

rgds,
Uday

Hi, Victor,

I believe this would solve your little puzzle:

db2 values date ( replace ('30/01/2006','/', '.'))

1
----------
01/30/2006

1 record(s) selected.

Of course, you could have your application substitute the slashes by periods and submit the string to the DATE function directly!

Hope this helps,

Willy