topic Re: conversion routines in Application Development and Automation Discussions

conversion routines

Former Member — Thu, 26 Feb 2009 09:58:37 GMT

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.

Re: conversion routines

Former Member — Thu, 26 Feb 2009 10:01:09 GMT

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.

Re: conversion routines

Former Member — Thu, 26 Feb 2009 14:22:35 GMT

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.

Re: conversion routines

Former Member — Thu, 26 Feb 2009 14:41:01 GMT

try FM CACS_TIMESTAMP_GET_DATE

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

regards,

Padma.