topic Problem in TimeStamp statement in Application Development and Automation Discussions

Problem in TimeStamp statement

Former Member — Tue, 09 Dec 2008 08:31:23 GMT

Hi,

I am using following abap stactement to create the timestamp from date, time and timezone.

CONVERT DATE <dat> TIME <tim>

INTO TIME STAMP <time_stamp> TIME ZONE <tz>.

Here timezone is UTC.

today i found that, if time is equal to 24:00:00(240000) then irerespective of date the generated timestamp will be equal to 0.

I am not able to figure it out what is wrong with time 24:00:00

is it expected behaviour and if yes then what is the rationale behind this.

Thanks,

Rahul

Re: Problem in TimeStamp statement

Former Member — Tue, 09 Dec 2008 08:40:30 GMT

hi,

The clock resets to 00000 at 2400 hrs.

Normally in international nomenclature, 12:00 am is denoted as 24:00 hrs or 00:00 hrs

Both are correct.

Hope this helps,

Rajat

Re: Problem in TimeStamp statement

Former Member — Tue, 09 Dec 2008 08:40:53 GMT

Hi Rahul,

Why r u giving 24:00:00.. after 23:59:59 it shld be 00:00:00. Is there a need for 24:00:00.

Thanks

Mohan

Re: Problem in TimeStamp statement

Former Member — Tue, 09 Dec 2008 08:50:06 GMT

use this FM VELO03_CONVERT_FROM_TIMESTAMP

Re: Problem in TimeStamp statement

Former Member — Tue, 09 Dec 2008 08:50:49 GMT

User can enter 24:00:00 in time field. Framework doesn't report any error on 24:00:00.

Even if we give time equal to 00:00:00 then also timestamp get created successfully.

But if we give time equal to space then generated timestamp is equal to 0, which is similar to 24:00:00

Thanks,

Rahul

Re: Problem in TimeStamp statement

Former Member — Tue, 09 Dec 2008 08:54:12 GMT

You can restrict it through the User Input validation..

Thanks

Mohan.

Re: Problem in TimeStamp statement

Former Member — Tue, 09 Dec 2008 09:18:01 GMT

I found that in Window timefield you can not enter 24:00:00 as time not even in Nokia mobile

is there any way other then restricting user from entring the wrong time?

thanks,

Rahul

Re: Problem in TimeStamp statement

Former Member — Tue, 09 Dec 2008 09:20:13 GMT

data: ccu_timestamp1 like CCUPEAKA-TIMESTAMP

The statement above means that ccu_timstamp1 is like field TIMESTAMP in

table CCUPEAKA.In this table timestamp is defined as NUMC14