topic Re: Convert to date in Application Development and Automation Discussions

Convert to date

Former Member — Mon, 03 Apr 2006 09:25:10 GMT

Hi,

I have a field that it's dec(15)(UTC time stamp) but I need it in date format.

Thanks

Former Member — Mon, 03 Apr 2006 09:29:11 GMT

Hi Laura,

You can use the CONVERT TIME STAMP to convert a timestamp into a date and time.

Regards,

John.

Former Member — Mon, 03 Apr 2006 09:29:33 GMT

Use one of the following FMs,

CONVERT_DATE_TO_EXTERNAL Conversion: Internal to external date (like screen conversion)

CONVERT_DATE_TO_INTERNAL Conversion: External to internal date (like screen conversion)

Extract the date part from the field you have, and pass to the function module.

Regards,

Ravi

Former Member — Mon, 03 Apr 2006 09:29:41 GMT

CONVERT TIME STAMP tst TIME ZONE tz INTO DATE d TIME t. 

where tst is ur timestamp value , tz is timezone ,

d is ur date

Former Member — Mon, 03 Apr 2006 09:33:20 GMT

hi,

you can try this way..

CONVERT TIME STAMP tstamp TIME ZONE 'UTC+12' INTO

DATE d TIME t.

Regards

vijay