topic Re: Change data/time in Application Development and Automation Discussions

Change data/time

Former Member — Thu, 23 Aug 2007 09:20:52 GMT

Hi All,

I want a FM which will convert the date for example 20070823101010 format to 23.08.2007 10:10:10 format. Please help.

Regards,

Jeetu

Re: Change data/time

Former Member — Thu, 23 Aug 2007 09:26:15 GMT

Hi,

For that use this code.

w_date = '20070823101010'

dat1 = w_date+0(8).

tim1 = w_date+8(6).

then u can use edit mask to print your time and date at apropriate format.

write:/ dat1 -editmask dd.mm.yyyy.

RewaRDS POINTS IF IT IS USEFUL

Re: Change data/time

former_member196280 — Thu, 23 Aug 2007 09:27:26 GMT

Easy way to do like this

Data: date(10),

time(8),

value(14).

value = '20070823101010'.

date0(2) = value6(2).

date+2(1) = '.' .

date3(2) = value4(2).

date+5(2) = '.'.

date7(4) = value0(4).

Time0(2) = value8(2).

time+2(1) = ':'.

time3(2) = value10(2).

time+5(1) = ':'.

time6(2) = value12(2).

Regards,

SaiRam

Re: Change data/time

Former Member — Thu, 23 Aug 2007 09:45:37 GMT

Hi Jeetu,

I've got an FM for you, please try using this,

<b>G_BIW_CONVERT_FROM_TIMESTAMP</b>

I've tried that for your example data and it is working fine.

<b>Reward points if this helps,</b>

Kiran

Re: Change data/time

Former Member — Thu, 23 Aug 2007 09:48:22 GMT

HI, U can Use convert statement to do this one.

EX:CONVERT TIME STAMP <time stamp>

TIME ZONE 'UTC' INTO DATE <date type variable>

Thanks,CSR.