LAE

Welcome to the LAE community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Discussions

Members

Resources

Events

 View Only

  • 1.  How can I subtract from a time value to get a new time

    Employee
    Posted 01-12-2015 08:01

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: johnvvu

    Suppose I have the time value of 15:03:20; how would I subtract 7 seconds from it to get a new time value of 15:03:13?

    Thank you,


  • 2.  RE: How can I subtract from a time value to get a new time

    Employee
    Posted 01-12-2015 08:13

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: ejones

    Interesting. I thought this was going to be trivial but did not find the timeAdjust() function like I expected.

    But you can use the dateTimeAdjust() function and a bit of typecasting
    sevenSecondsEarlier = timestamp('timeValue').dateTimeAdjust(7,"seconds") .time()


  • 3.  RE: How can I subtract from a time value to get a new time

    Employee
    Posted 01-12-2015 08:24

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: johnvvu

    Thank you! That worked.