topic Re: Timestamp - Date in Application Development and Automation Discussions

Timestamp - Date

Former Member — Tue, 19 Jun 2007 15:58:54 GMT

Hi All,

Acc to my requirement I want to get the date(YYYY-MM-DD) from the 15 digit decimal timestamp.

Is there any FM to get the date out from the timestamp.

Thanks in Advance,

Praveen

Re: Timestamp - Date

Former Member — Tue, 19 Jun 2007 16:03:09 GMT

do the offsetting of that timestamp field and take the 8 char date field

or by offsetting separate the YYYY, MM and DD fields and concatenate them again

Reward points for useful Answers

Regards

Anji

Re: Timestamp - Date

Former Member — Tue, 19 Jun 2007 16:04:25 GMT

Hi Praveen,

Use FM <b>HRIQ_PROC_DH_TIMESTMP_DATETIME</b>

Regards

Aneesh.

Re: Timestamp - Date

Former Member — Tue, 19 Jun 2007 16:04:37 GMT

Hi,

You can use the syntax

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


DATA: 
  tstamp  TYPE timestamp, 
  d       TYPE D VALUE '19971224', 

  t       TYPE T VALUE '235500'. 

SET COUNTRY 'US'. 


CONVERT DATE d TIME t INTO 
        TIME STAMP tstamp TIME ZONE 'UTC+12'. 

                        " tstamp :    19971224115500 
                        "          (12/24/1997 11:55:00) 

CONVERT TIME STAMP tstamp TIME ZONE 'UTC+12' INTO 
        DATE d TIME t. 

WRITE: (10) d,      " 12/24/1997 
    /, (8)  t.      " 23:55:00

Thanks

Naren

Re: Timestamp - Date

Former Member — Tue, 19 Jun 2007 16:07:03 GMT

hi Praveen,

date = timestamp+0(8)
time = timestamp+8(6).

else try this way

convert time stamp wa_rseqdone_ts
time zone sy-zonlo
into date wa_ts_date
time wa_ts_time.

check this link for full details

http://www.bwexpertonline.com/downloads/DBConnectMakingDELTAABAPCode.doc

Regards,

Santosh

Re: Timestamp - Date

Former Member — Wed, 20 Jun 2007 03:22:28 GMT

Thank you all,

I got the solution.