Urgent DB2 date conversion help

nivasreddy007 · #1 (**permalink**) 06-27-07, 14:33

Hi ,

Can you tell me what is wrong with the following expression.I am unable to covert it to the date type.

values DATE(CHAR(CAST((4+1) AS CHAR(2)) || '/01/' || CAST(YEAR(CURRENT_DATE) AS CHAR(4))))

n_i · #2 (**permalink**) 06-27-07, 15:23

It may help if you look at the result of VALUES CHAR(CAST((4+1) AS CHAR(2)) || '/01/' || CAST(YEAR(CURRENT_DATE) AS CHAR(4)))

nivasreddy007 · #3 (**permalink**) 06-27-07, 15:28

'5 /01/2007'

Above is the result for the expression without date function..Any idea why the above result is not taken by DATE function??

Thanks

nivasreddy007 · #4 (**permalink**) 06-27-07, 15:48

I understood the problem now..The day part was defined as char(2) and there was an unwanted space being inserted..Thanks for the reply

stolze · #5 (**permalink**) 06-29-07, 03:28

You can use RTRIM() to get rid of such spaces.

Internet Services

Web Development

Digital Marketing

Consumer Tech