<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Re: Convert system time into User local time. in Application Development and Automation Discussions</title>
    <link>https://community.sap.com/t5/application-development-and-automation-discussions/convert-system-time-into-user-local-time/m-p/3921620#M939573</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;thank you&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Tue, 27 May 2008 10:06:34 GMT</pubDate>
    <dc:creator>Former Member</dc:creator>
    <dc:date>2008-05-27T10:06:34Z</dc:date>
    <item>
      <title>Convert system time into User local time.</title>
      <link>https://community.sap.com/t5/application-development-and-automation-discussions/convert-system-time-into-user-local-time/m-p/3921616#M939569</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hi,&lt;/P&gt;&lt;P&gt;How to convert System time into User Local time.&lt;/P&gt;&lt;P&gt;Are there any FMs available.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Regards,&lt;/P&gt;&lt;P&gt;Kiran&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Tue, 27 May 2008 09:43:19 GMT</pubDate>
      <guid>https://community.sap.com/t5/application-development-and-automation-discussions/convert-system-time-into-user-local-time/m-p/3921616#M939569</guid>
      <dc:creator>Former Member</dc:creator>
      <dc:date>2008-05-27T09:43:19Z</dc:date>
    </item>
    <item>
      <title>Re: Convert system time into User local time.</title>
      <link>https://community.sap.com/t5/application-development-and-automation-discussions/convert-system-time-into-user-local-time/m-p/3921617#M939570</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Just use the system variable SY-TIMLO...&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Regards&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Tue, 27 May 2008 09:46:59 GMT</pubDate>
      <guid>https://community.sap.com/t5/application-development-and-automation-discussions/convert-system-time-into-user-local-time/m-p/3921617#M939570</guid>
      <dc:creator>Former Member</dc:creator>
      <dc:date>2008-05-27T09:46:59Z</dc:date>
    </item>
    <item>
      <title>Re: Convert system time into User local time.</title>
      <link>https://community.sap.com/t5/application-development-and-automation-discussions/convert-system-time-into-user-local-time/m-p/3921618#M939571</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Check the FM &lt;/P&gt;&lt;P&gt;RKE_TIMESTAMP_CONVERT_OUTPUT&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Hope it helps&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Tue, 27 May 2008 09:49:58 GMT</pubDate>
      <guid>https://community.sap.com/t5/application-development-and-automation-discussions/convert-system-time-into-user-local-time/m-p/3921618#M939571</guid>
      <dc:creator>Former Member</dc:creator>
      <dc:date>2008-05-27T09:49:58Z</dc:date>
    </item>
    <item>
      <title>Re: Convert system time into User local time.</title>
      <link>https://community.sap.com/t5/application-development-and-automation-discussions/convert-system-time-into-user-local-time/m-p/3921619#M939572</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;hi,&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;There is just one simple funda behind the Date and time logic in SAP.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;-&amp;gt; It is absolutely useless to store Date and time directly in DB. Why ?&lt;/P&gt;&lt;P&gt;Because 00:00 a.m in London could mean 05:30 in India !! So If I (in India) store a Date 1st Feb 2008 , 10:00 a.m .. This time for a person in London could be invalid.. because he is behind your time zone..&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;So the solution is to store the date/times in Timestamps format. Taking the above example.. 1st Feb 2008, 10:00 a.m (in India) will be stored as 20080201043000.&lt;/P&gt;&lt;P&gt;This time if seen in German Time zone will look as : 1st Feb 2008, 05:30 a.m.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Simple right &lt;SPAN __jive_emoticon_name="happy"&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;-&amp;gt; In India we store date as DD.MM.YYYY while in other countries they store it as MM.DD.YYYY.&lt;/P&gt;&lt;P&gt;The separator could be . or - or / .&lt;/P&gt;&lt;P&gt;The date format is user dependent. I might prefer to store it as DD.MM.YYYY and you might want to store it as MM-DD-YYYY.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;System does not bother what your format is. It always stores in YYYYMMDD (8 Char)&lt;/P&gt;&lt;P&gt;On screens if you want to display Date then it must always be shown in that users format who is seeing it. How to get this done ?&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;DATA : lv_date(10) type c.&lt;/P&gt;&lt;P&gt;write sy-datum into lv_date.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;So in LV_DATE variable the date will be stores in the users format.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Simple right &lt;SPAN __jive_emoticon_name="happy"&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;There are function modules that do the same. But normally we should avoid use of FM to make code simpler, short and easy... no complications at all .. &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;You can use system variables sy-datlo (Local Date for Current User) and sy-timlo ( Local Time of Current User ).&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;You can also use GET TIME statement.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;reward if useful,&lt;/P&gt;&lt;P&gt;preet&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Tue, 27 May 2008 09:58:58 GMT</pubDate>
      <guid>https://community.sap.com/t5/application-development-and-automation-discussions/convert-system-time-into-user-local-time/m-p/3921619#M939572</guid>
      <dc:creator>Former Member</dc:creator>
      <dc:date>2008-05-27T09:58:58Z</dc:date>
    </item>
    <item>
      <title>Re: Convert system time into User local time.</title>
      <link>https://community.sap.com/t5/application-development-and-automation-discussions/convert-system-time-into-user-local-time/m-p/3921620#M939573</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;thank you&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Tue, 27 May 2008 10:06:34 GMT</pubDate>
      <guid>https://community.sap.com/t5/application-development-and-automation-discussions/convert-system-time-into-user-local-time/m-p/3921620#M939573</guid>
      <dc:creator>Former Member</dc:creator>
      <dc:date>2008-05-27T10:06:34Z</dc:date>
    </item>
  </channel>
</rss>

