Timestamp

[Former Member]

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

[guillaume-hrc]

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

[guillaume-hrc]

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>

[Former Member]

Check transaction code STZBD or table TZONE.

Regards

Damasus

[Former Member]

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