trouble understanding time conversions










2















I have some trouble understanding time conversions in python.
I have two identical time_struct objects



In [22]: local_dt
Out[22]: datetime.datetime(2000, 1, 1, 0, 0, tzinfo=<DstTzInfo 'America/Los_Angeles' PST-1 day, 16:00:00 STD>)
In [23]: local_dt.timetuple()
Out[24]: time.struct_time(tm_year=2000, tm_mon=1, tm_mday=1, tm_hour=0, tm_min=0, tm_sec=0, tm_wday=5, tm_yday=1, tm_isdst=0)


When I feed it to the time.mktime function on one machine



time.mktime(local_dt.timetuple())


it returns 946681200.0



On a second machine I get a different answer



In [31]: local_dt.timetuple() 
Out[31]: time.struct_time(tm_year=2000, tm_mon=1, tm_mday=1, tm_hour=0, tm_min=0, tm_sec=0, tm_wday=5, tm_yday=1, tm_isdst=0)

In [32]: time.mktime(local_dt.timetuple())
Out[32]: 946684800.0


The machines have different timezones, though:



In [44]: time.tzname 
Out[44]: ('Europe', 'Europe')

In [45]: time.tzname
Out[45]: ('CET', 'CEST')


The documentation on the time module says:




Use the following functions to convert between time representations:
struct_time in local time seconds since the epoch mktime()




As I understand my local time is "America/Los_Angeles" so seconds since epoch should be exactly the same and not be depending on the system configuration.



What am I misunderstanding? How do I have to calculate the timestamp correctly then?










share|improve this question






















  • The delta between the two values is exactly 3600 seconds (one hour), which smells to me like a Daylight Savings Time issue. That said, it looks like they are set up the same, so I'm not sure why this delta exists.

    – Jonah Bishop
    Nov 14 '18 at 14:16
















2















I have some trouble understanding time conversions in python.
I have two identical time_struct objects



In [22]: local_dt
Out[22]: datetime.datetime(2000, 1, 1, 0, 0, tzinfo=<DstTzInfo 'America/Los_Angeles' PST-1 day, 16:00:00 STD>)
In [23]: local_dt.timetuple()
Out[24]: time.struct_time(tm_year=2000, tm_mon=1, tm_mday=1, tm_hour=0, tm_min=0, tm_sec=0, tm_wday=5, tm_yday=1, tm_isdst=0)


When I feed it to the time.mktime function on one machine



time.mktime(local_dt.timetuple())


it returns 946681200.0



On a second machine I get a different answer



In [31]: local_dt.timetuple() 
Out[31]: time.struct_time(tm_year=2000, tm_mon=1, tm_mday=1, tm_hour=0, tm_min=0, tm_sec=0, tm_wday=5, tm_yday=1, tm_isdst=0)

In [32]: time.mktime(local_dt.timetuple())
Out[32]: 946684800.0


The machines have different timezones, though:



In [44]: time.tzname 
Out[44]: ('Europe', 'Europe')

In [45]: time.tzname
Out[45]: ('CET', 'CEST')


The documentation on the time module says:




Use the following functions to convert between time representations:
struct_time in local time seconds since the epoch mktime()




As I understand my local time is "America/Los_Angeles" so seconds since epoch should be exactly the same and not be depending on the system configuration.



What am I misunderstanding? How do I have to calculate the timestamp correctly then?










share|improve this question






















  • The delta between the two values is exactly 3600 seconds (one hour), which smells to me like a Daylight Savings Time issue. That said, it looks like they are set up the same, so I'm not sure why this delta exists.

    – Jonah Bishop
    Nov 14 '18 at 14:16














2












2








2








I have some trouble understanding time conversions in python.
I have two identical time_struct objects



In [22]: local_dt
Out[22]: datetime.datetime(2000, 1, 1, 0, 0, tzinfo=<DstTzInfo 'America/Los_Angeles' PST-1 day, 16:00:00 STD>)
In [23]: local_dt.timetuple()
Out[24]: time.struct_time(tm_year=2000, tm_mon=1, tm_mday=1, tm_hour=0, tm_min=0, tm_sec=0, tm_wday=5, tm_yday=1, tm_isdst=0)


When I feed it to the time.mktime function on one machine



time.mktime(local_dt.timetuple())


it returns 946681200.0



On a second machine I get a different answer



In [31]: local_dt.timetuple() 
Out[31]: time.struct_time(tm_year=2000, tm_mon=1, tm_mday=1, tm_hour=0, tm_min=0, tm_sec=0, tm_wday=5, tm_yday=1, tm_isdst=0)

In [32]: time.mktime(local_dt.timetuple())
Out[32]: 946684800.0


The machines have different timezones, though:



In [44]: time.tzname 
Out[44]: ('Europe', 'Europe')

In [45]: time.tzname
Out[45]: ('CET', 'CEST')


The documentation on the time module says:




Use the following functions to convert between time representations:
struct_time in local time seconds since the epoch mktime()




As I understand my local time is "America/Los_Angeles" so seconds since epoch should be exactly the same and not be depending on the system configuration.



What am I misunderstanding? How do I have to calculate the timestamp correctly then?










share|improve this question














I have some trouble understanding time conversions in python.
I have two identical time_struct objects



In [22]: local_dt
Out[22]: datetime.datetime(2000, 1, 1, 0, 0, tzinfo=<DstTzInfo 'America/Los_Angeles' PST-1 day, 16:00:00 STD>)
In [23]: local_dt.timetuple()
Out[24]: time.struct_time(tm_year=2000, tm_mon=1, tm_mday=1, tm_hour=0, tm_min=0, tm_sec=0, tm_wday=5, tm_yday=1, tm_isdst=0)


When I feed it to the time.mktime function on one machine



time.mktime(local_dt.timetuple())


it returns 946681200.0



On a second machine I get a different answer



In [31]: local_dt.timetuple() 
Out[31]: time.struct_time(tm_year=2000, tm_mon=1, tm_mday=1, tm_hour=0, tm_min=0, tm_sec=0, tm_wday=5, tm_yday=1, tm_isdst=0)

In [32]: time.mktime(local_dt.timetuple())
Out[32]: 946684800.0


The machines have different timezones, though:



In [44]: time.tzname 
Out[44]: ('Europe', 'Europe')

In [45]: time.tzname
Out[45]: ('CET', 'CEST')


The documentation on the time module says:




Use the following functions to convert between time representations:
struct_time in local time seconds since the epoch mktime()




As I understand my local time is "America/Los_Angeles" so seconds since epoch should be exactly the same and not be depending on the system configuration.



What am I misunderstanding? How do I have to calculate the timestamp correctly then?







python time epoch datetime-conversion






share|improve this question













share|improve this question











share|improve this question




share|improve this question










asked Nov 14 '18 at 14:12









LarsVegasLarsVegas

2,32842752




2,32842752












  • The delta between the two values is exactly 3600 seconds (one hour), which smells to me like a Daylight Savings Time issue. That said, it looks like they are set up the same, so I'm not sure why this delta exists.

    – Jonah Bishop
    Nov 14 '18 at 14:16


















  • The delta between the two values is exactly 3600 seconds (one hour), which smells to me like a Daylight Savings Time issue. That said, it looks like they are set up the same, so I'm not sure why this delta exists.

    – Jonah Bishop
    Nov 14 '18 at 14:16

















The delta between the two values is exactly 3600 seconds (one hour), which smells to me like a Daylight Savings Time issue. That said, it looks like they are set up the same, so I'm not sure why this delta exists.

– Jonah Bishop
Nov 14 '18 at 14:16






The delta between the two values is exactly 3600 seconds (one hour), which smells to me like a Daylight Savings Time issue. That said, it looks like they are set up the same, so I'm not sure why this delta exists.

– Jonah Bishop
Nov 14 '18 at 14:16













2 Answers
2






active

oldest

votes


















1














time.mktime() interprets the timetuple based on the local machine's timezone. Notice how your timetuple object doesn't contain any timezone info, so the timestamp created will always vary based on timezone set on the local machine. Thus it's entirely understandable why the same time.mktime(local_dt.timetuple()) returns different value on those two machines.



You can use local_dt.timestamp() instead, while both are essentially the same...




Naive datetime instances are assumed to represent local time and this method relies on the platform C mktime() function to perform the conversion.




... But since you're creating the timestamp directly from the non-naive datetime object, it still retains the timezone info and can shift the time accordingly:




For aware datetime instances, the return value is computed as:



(dt - datetime(1970, 1, 1, tzinfo=timezone.utc)).total_seconds()




Observe:



>>> est = datetime.datetime(1999, 12, 31, 19, 0).astimezone(pytz.timezone('EST'))
>>> utc = est.astimezone(pytz.timezone('UTC'))
>>> est
datetime.datetime(1999, 12, 31, 19, 0, tzinfo=<StaticTzInfo 'EST'>)
>>> utc
datetime.datetime(2000, 1, 1, 0, 0, tzinfo=<UTC>)
>>> est.timestamp()
946684800.0
>>> utc.timestamp()
946684800.0 # same as est
>>> time.mktime(est.timetuple())
946684800.0
>>> time.mktime(utc.timetuple())
946702800.0 # different than est


The last time.mktime() processed utc.timetuple() as a local time since the timezone info was not passed. You can notice it's offset by 18000 (time.timezone for EST, my time zone).






share|improve this answer
































    0














    As you said : "The machines have different timezones, though:" and doc said: "in local time".



    Your "local time" is not the same on both machine : one is Europe/europe (probably GMT, so UTC+0), the other one is CEST (UTC +1).



    see https://www.timeanddate.com/time/zones/eu




    Central European Time (CET) is 1 hour ahead of Coordinated Universal Time (UTC).
    This time zone is in use during standard time in: Europe, Africa.




    I think you want to convert your datetime into "UTC+0 datetime"






    share|improve this answer






















      Your Answer






      StackExchange.ifUsing("editor", function ()
      StackExchange.using("externalEditor", function ()
      StackExchange.using("snippets", function ()
      StackExchange.snippets.init();
      );
      );
      , "code-snippets");

      StackExchange.ready(function()
      var channelOptions =
      tags: "".split(" "),
      id: "1"
      ;
      initTagRenderer("".split(" "), "".split(" "), channelOptions);

      StackExchange.using("externalEditor", function()
      // Have to fire editor after snippets, if snippets enabled
      if (StackExchange.settings.snippets.snippetsEnabled)
      StackExchange.using("snippets", function()
      createEditor();
      );

      else
      createEditor();

      );

      function createEditor()
      StackExchange.prepareEditor(
      heartbeatType: 'answer',
      autoActivateHeartbeat: false,
      convertImagesToLinks: true,
      noModals: true,
      showLowRepImageUploadWarning: true,
      reputationToPostImages: 10,
      bindNavPrevention: true,
      postfix: "",
      imageUploader:
      brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
      contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
      allowUrls: true
      ,
      onDemand: true,
      discardSelector: ".discard-answer"
      ,immediatelyShowMarkdownHelp:true
      );



      );













      draft saved

      draft discarded


















      StackExchange.ready(
      function ()
      StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53302209%2ftrouble-understanding-time-conversions%23new-answer', 'question_page');

      );

      Post as a guest















      Required, but never shown

























      2 Answers
      2






      active

      oldest

      votes








      2 Answers
      2






      active

      oldest

      votes









      active

      oldest

      votes






      active

      oldest

      votes









      1














      time.mktime() interprets the timetuple based on the local machine's timezone. Notice how your timetuple object doesn't contain any timezone info, so the timestamp created will always vary based on timezone set on the local machine. Thus it's entirely understandable why the same time.mktime(local_dt.timetuple()) returns different value on those two machines.



      You can use local_dt.timestamp() instead, while both are essentially the same...




      Naive datetime instances are assumed to represent local time and this method relies on the platform C mktime() function to perform the conversion.




      ... But since you're creating the timestamp directly from the non-naive datetime object, it still retains the timezone info and can shift the time accordingly:




      For aware datetime instances, the return value is computed as:



      (dt - datetime(1970, 1, 1, tzinfo=timezone.utc)).total_seconds()




      Observe:



      >>> est = datetime.datetime(1999, 12, 31, 19, 0).astimezone(pytz.timezone('EST'))
      >>> utc = est.astimezone(pytz.timezone('UTC'))
      >>> est
      datetime.datetime(1999, 12, 31, 19, 0, tzinfo=<StaticTzInfo 'EST'>)
      >>> utc
      datetime.datetime(2000, 1, 1, 0, 0, tzinfo=<UTC>)
      >>> est.timestamp()
      946684800.0
      >>> utc.timestamp()
      946684800.0 # same as est
      >>> time.mktime(est.timetuple())
      946684800.0
      >>> time.mktime(utc.timetuple())
      946702800.0 # different than est


      The last time.mktime() processed utc.timetuple() as a local time since the timezone info was not passed. You can notice it's offset by 18000 (time.timezone for EST, my time zone).






      share|improve this answer





























        1














        time.mktime() interprets the timetuple based on the local machine's timezone. Notice how your timetuple object doesn't contain any timezone info, so the timestamp created will always vary based on timezone set on the local machine. Thus it's entirely understandable why the same time.mktime(local_dt.timetuple()) returns different value on those two machines.



        You can use local_dt.timestamp() instead, while both are essentially the same...




        Naive datetime instances are assumed to represent local time and this method relies on the platform C mktime() function to perform the conversion.




        ... But since you're creating the timestamp directly from the non-naive datetime object, it still retains the timezone info and can shift the time accordingly:




        For aware datetime instances, the return value is computed as:



        (dt - datetime(1970, 1, 1, tzinfo=timezone.utc)).total_seconds()




        Observe:



        >>> est = datetime.datetime(1999, 12, 31, 19, 0).astimezone(pytz.timezone('EST'))
        >>> utc = est.astimezone(pytz.timezone('UTC'))
        >>> est
        datetime.datetime(1999, 12, 31, 19, 0, tzinfo=<StaticTzInfo 'EST'>)
        >>> utc
        datetime.datetime(2000, 1, 1, 0, 0, tzinfo=<UTC>)
        >>> est.timestamp()
        946684800.0
        >>> utc.timestamp()
        946684800.0 # same as est
        >>> time.mktime(est.timetuple())
        946684800.0
        >>> time.mktime(utc.timetuple())
        946702800.0 # different than est


        The last time.mktime() processed utc.timetuple() as a local time since the timezone info was not passed. You can notice it's offset by 18000 (time.timezone for EST, my time zone).






        share|improve this answer



























          1












          1








          1







          time.mktime() interprets the timetuple based on the local machine's timezone. Notice how your timetuple object doesn't contain any timezone info, so the timestamp created will always vary based on timezone set on the local machine. Thus it's entirely understandable why the same time.mktime(local_dt.timetuple()) returns different value on those two machines.



          You can use local_dt.timestamp() instead, while both are essentially the same...




          Naive datetime instances are assumed to represent local time and this method relies on the platform C mktime() function to perform the conversion.




          ... But since you're creating the timestamp directly from the non-naive datetime object, it still retains the timezone info and can shift the time accordingly:




          For aware datetime instances, the return value is computed as:



          (dt - datetime(1970, 1, 1, tzinfo=timezone.utc)).total_seconds()




          Observe:



          >>> est = datetime.datetime(1999, 12, 31, 19, 0).astimezone(pytz.timezone('EST'))
          >>> utc = est.astimezone(pytz.timezone('UTC'))
          >>> est
          datetime.datetime(1999, 12, 31, 19, 0, tzinfo=<StaticTzInfo 'EST'>)
          >>> utc
          datetime.datetime(2000, 1, 1, 0, 0, tzinfo=<UTC>)
          >>> est.timestamp()
          946684800.0
          >>> utc.timestamp()
          946684800.0 # same as est
          >>> time.mktime(est.timetuple())
          946684800.0
          >>> time.mktime(utc.timetuple())
          946702800.0 # different than est


          The last time.mktime() processed utc.timetuple() as a local time since the timezone info was not passed. You can notice it's offset by 18000 (time.timezone for EST, my time zone).






          share|improve this answer















          time.mktime() interprets the timetuple based on the local machine's timezone. Notice how your timetuple object doesn't contain any timezone info, so the timestamp created will always vary based on timezone set on the local machine. Thus it's entirely understandable why the same time.mktime(local_dt.timetuple()) returns different value on those two machines.



          You can use local_dt.timestamp() instead, while both are essentially the same...




          Naive datetime instances are assumed to represent local time and this method relies on the platform C mktime() function to perform the conversion.




          ... But since you're creating the timestamp directly from the non-naive datetime object, it still retains the timezone info and can shift the time accordingly:




          For aware datetime instances, the return value is computed as:



          (dt - datetime(1970, 1, 1, tzinfo=timezone.utc)).total_seconds()




          Observe:



          >>> est = datetime.datetime(1999, 12, 31, 19, 0).astimezone(pytz.timezone('EST'))
          >>> utc = est.astimezone(pytz.timezone('UTC'))
          >>> est
          datetime.datetime(1999, 12, 31, 19, 0, tzinfo=<StaticTzInfo 'EST'>)
          >>> utc
          datetime.datetime(2000, 1, 1, 0, 0, tzinfo=<UTC>)
          >>> est.timestamp()
          946684800.0
          >>> utc.timestamp()
          946684800.0 # same as est
          >>> time.mktime(est.timetuple())
          946684800.0
          >>> time.mktime(utc.timetuple())
          946702800.0 # different than est


          The last time.mktime() processed utc.timetuple() as a local time since the timezone info was not passed. You can notice it's offset by 18000 (time.timezone for EST, my time zone).







          share|improve this answer














          share|improve this answer



          share|improve this answer








          edited Nov 14 '18 at 18:52

























          answered Nov 14 '18 at 18:46









          IdlehandsIdlehands

          5,1901619




          5,1901619























              0














              As you said : "The machines have different timezones, though:" and doc said: "in local time".



              Your "local time" is not the same on both machine : one is Europe/europe (probably GMT, so UTC+0), the other one is CEST (UTC +1).



              see https://www.timeanddate.com/time/zones/eu




              Central European Time (CET) is 1 hour ahead of Coordinated Universal Time (UTC).
              This time zone is in use during standard time in: Europe, Africa.




              I think you want to convert your datetime into "UTC+0 datetime"






              share|improve this answer



























                0














                As you said : "The machines have different timezones, though:" and doc said: "in local time".



                Your "local time" is not the same on both machine : one is Europe/europe (probably GMT, so UTC+0), the other one is CEST (UTC +1).



                see https://www.timeanddate.com/time/zones/eu




                Central European Time (CET) is 1 hour ahead of Coordinated Universal Time (UTC).
                This time zone is in use during standard time in: Europe, Africa.




                I think you want to convert your datetime into "UTC+0 datetime"






                share|improve this answer

























                  0












                  0








                  0







                  As you said : "The machines have different timezones, though:" and doc said: "in local time".



                  Your "local time" is not the same on both machine : one is Europe/europe (probably GMT, so UTC+0), the other one is CEST (UTC +1).



                  see https://www.timeanddate.com/time/zones/eu




                  Central European Time (CET) is 1 hour ahead of Coordinated Universal Time (UTC).
                  This time zone is in use during standard time in: Europe, Africa.




                  I think you want to convert your datetime into "UTC+0 datetime"






                  share|improve this answer













                  As you said : "The machines have different timezones, though:" and doc said: "in local time".



                  Your "local time" is not the same on both machine : one is Europe/europe (probably GMT, so UTC+0), the other one is CEST (UTC +1).



                  see https://www.timeanddate.com/time/zones/eu




                  Central European Time (CET) is 1 hour ahead of Coordinated Universal Time (UTC).
                  This time zone is in use during standard time in: Europe, Africa.




                  I think you want to convert your datetime into "UTC+0 datetime"







                  share|improve this answer












                  share|improve this answer



                  share|improve this answer










                  answered Nov 14 '18 at 14:27









                  DylannCordelDylannCordel

                  39538




                  39538



























                      draft saved

                      draft discarded
















































                      Thanks for contributing an answer to Stack Overflow!


                      • Please be sure to answer the question. Provide details and share your research!

                      But avoid


                      • Asking for help, clarification, or responding to other answers.

                      • Making statements based on opinion; back them up with references or personal experience.

                      To learn more, see our tips on writing great answers.




                      draft saved


                      draft discarded














                      StackExchange.ready(
                      function ()
                      StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53302209%2ftrouble-understanding-time-conversions%23new-answer', 'question_page');

                      );

                      Post as a guest















                      Required, but never shown





















































                      Required, but never shown














                      Required, but never shown












                      Required, but never shown







                      Required, but never shown

































                      Required, but never shown














                      Required, but never shown












                      Required, but never shown







                      Required, but never shown







                      這個網誌中的熱門文章

                      How to read a connectionString WITH PROVIDER in .NET Core?

                      In R, how to develop a multiplot heatmap.2 figure showing key labels successfully

                      Museum of Modern and Contemporary Art of Trento and Rovereto