Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Convert to date

Former Member
0 Kudos

Hi,

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

Thanks

4 REPLIES 4

Former Member
0 Kudos

Hi Laura,

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

Regards,

John.

former_member181962
Active Contributor
0 Kudos

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
0 Kudos
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

0 Kudos

hi,

you can try this way..

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

DATE d TIME t.

Regards

vijay