Automic Workload Automation

  • Private Community

  • 1.  Quick help, How do we find the difference in hours between 2 timestamps.

    Posted Jun 20, 2018 09:17 AM

    A quick question. How do we find the difference in hours between 2 timestamps when the timestamps are in  "YYYY-MM-DD HH:MM:SS" format? #TIMESTAMP

    Example:

    Timestamp1= 2018-06-19-11:45:50

    Timestamp2= 2018-05-10-20:35:20

     

    Please let me know if there are any ways to find it.

     

    Thanks in advance!

     



  • 2.  Re: Quick help, How do we find the difference in hours between 2 timestamps.

    Posted Jun 22, 2018 10:51 AM

    Hi

     

    the easiest way is cutting out the time and then using DIFF_TIME

     

    Automic 

     

    cheers, Wolfgang



  • 3.  Re: Quick help, How do we find the difference in hours between 2 timestamps.

    Posted Jun 22, 2018 04:22 PM

    I would also try out the SUB_TIMESTAMP() function which subtracts one timestamp from another.  It might be able to give you what you want?