cancel
Showing results for 
Search instead for 
Did you mean: 

Convert Date using Day Light Time Saving

Former Member
0 Kudos

Hi All,

I have to convert date in system date - EST to UTC considering if we have day light saving it turned on.. I have checked the sap table - TTZDV which is consider for day light saving.. And it is giving the day light start date from 6 Apr 2014, but day light start time is 9 March 2014.

The standard FM or convert statement is considering the entry in table - TTZDV. The FUNCTION 'IB_CONVERT_INTO_TIMESTAMP' consider the Daylight time saving but it is reflecting the change in time from 6 Apr 2014 as per table.

Can any one advice how we can match the system with actual day light start date or end date. Do we need to update table - TTZDV or any other suggestion.. Please advice..

Regards,

Rajesh

Accepted Solutions (0)

Answers (2)

Answers (2)

wei_zhang119
Associate
Associate
0 Kudos

Hi Rajesh,

Your basis team may update your timezone settings to the latest according to SAP note 198411.

198411 - Current data and information about time zones

Restart your sap system after you make the timezone changes. The DST rule for USA in your sap system will then match with the actual day light rule.

Best regards,
Wei

raymond_giuseppi
Active Contributor
0 Kudos

Open the attachment of note 198411 - Current data and information about time zones to get file tzdata.dat, then useprogram TZCUSTIM.

Regards,

Raymond

Former Member
0 Kudos
Former Member
0 Kudos

Thanks Vikram for link, Can you provide more information, how to solve the issue or what we can do from abap development or what BASIS team needs to do on this..

Regards,

Rajesh