Convert to date

[Former Member]

Hi,

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

Thanks

[Former Member]

Hi Laura,

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

Regards,

John.

[former_member181962]

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]

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_member188685]

hi,

you can try this way..

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

DATE d TIME t.

Regards

vijay