topic Re: Timestamp in Application Development and Automation Discussions

Timestamp

Former Member — Tue, 01 Aug 2006 10:52:05 GMT

Hi,

I have requirement to convert the date into a timestamp. For this Im using the FM VELO03_CONVERT_INTO_TIMESTAMP. The Fm inturn does the conversion by the statement CONVERT DATE DT TIME TIM

INTO TIME STAMP TSMPT TIME ZONE TZONE.

Now my doubt is whats the role of Timezone in the conversion and is there any configuration maintained for the timezone.

Thanks & Regards

Saikiran

Re: Timestamp

guillaume-hrc — Tue, 01 Aug 2006 11:16:55 GMT

Hi Saikiran,

Check table TTZZ in transaction SE11.

The whole interest of timestamps is to allow a single time reference across all the company (thus, accross several time zones for a world-wide company).

Best regards,

Guillaume

Message was edited by: Guillaume Garcia

Re: Timestamp

Former Member — Tue, 01 Aug 2006 11:21:39 GMT

Check transaction code STZBD or table TZONE.

Regards

Damasus

Re: Timestamp

guillaume-hrc — Tue, 01 Aug 2006 11:21:43 GMT

Taken for the Help (F1) :

<b>Differences between UTC time and local time or summertime</b>

<i>The rules for converting UTC timestamps into local time (or vice versa) are stored in the tables TTZZ, TTZR, TTZD, TTZDF, and TTZDV. TTZZ contains the time zones and the rules for the time difference between the time zone, its summertime, and UTC time. The differences themselves are stored in tables TTZR and TTZD.</i>

Re: Timestamp

Former Member — Tue, 01 Aug 2006 11:32:08 GMT

Basically, the timezone is used to interpret whether to apply day time saving etc depending on the selected date. Since, DST etc applies only for particular zones.

Hope that satisfies your requriment.

Regards

Anurag