converting character to decimal format

[Former Member]

hi

i am working on a development where the selection screen has date and time as select options.

and based on the input i have to concatenate date and time into the format- DD.MM.YYY HH.MM.SS

there is a value in the table that has a field containing the above value and i have to fetch the data based on this input.

Now the problem is the field in the table is of format DECIMAL of 16 length.

i want to know how can i pass this value to the select statement.

thanks in advance

[Former Member]

hi

i am working on a development where the selection screen has date and time as select options.

and based on the input i have to concatenate date and time into the format- DD.MM.YYY HH.MM.SS

there is a value in the table that has a field containing the above value and i have to fetch the data based on this input.

Now the problem is the field in the table is of format DECIMAL of 16 length.

i want to know how can i pass this value to the select statement.

thanks in advance

[Former Member]

Hi ,

Please check the blog on the below link.

[;

This will solve your query.

Regards

Abhii......

[Former Member]

Hi Venkat,

Concatenate the date and time and pass the value to that field it will work. The output represantion will be in DD.MM.YYY HH.MM.SS but the internal storage will be YYYYMMDDHHMMSS.