conversion routines

[Former Member]

Hi.

I am made a view. I combined 4 system tables and got relational datas. But in one field I have to convert the value. I don't know how to do.

the field is date_1 of crmd_order_index table. System holds the date like 20081231220000, because of the time difference from England. but the real date sould be seen as 01.01.2009 in the view field.

This is not a code. This view will be used for a searh help in a table.

How can I convert this date field?

Thank you for your help.

[Former Member]

you can use bewlo function modules to contert to date

PK_DATE_TIME_INTO_TIMESTAMP -- Converts the date and time into TimeStamp.

PK_TIMESTAMP_INTO_DATE_TIME --- Converts Time Stamp into date and time.

[Former Member]

Hi.

I need a conversion exit function but I don't know how to convert the 20081231220000 type date into the 01.01.2009 type. I've checked the original table. Its data type is DEC, lenght 15 and decimals 0.

I tried to add 2 hours to this date so I could get the date I wanted.

But I could not do it. Please help me.

Thank you all.

[Former Member]

try FM CACS_TIMESTAMP_GET_DATE

Pass the timestamp to this FM, you get date and time separately.

regards,

Padma.