Skip to content

    • Charting

    Charting

    Add Time to Datetime

    Member
    in Charting

    I have two columns `timePlaced` is a datetime, while `timeEstimate` is an integer that represents minuets. Using the below beast mode I am able to convert `timeEstimate` to minuets, ex 10 turns to 00:10:00.


    SEC_TO_TIME(`timeEstimate`*60)


    When I try to add it to `timePlaced` using the fowling beast mode I get null values.


    ADDTIME(time(`timePlaced`),SEC_TO_TIME(`timeEstimate`*60))


    I have used variations including wrapping the entire formula in TIME(), using "+" instead of ADDTIME(), but none return the correct value. Is there a specific syntax or function needed to add duration to a time value?


    Sample image of card below:

    Image
    Domo_Add_Min_To_DATETIME.PNG
    Uploaded 11.41 KB


    Tagged:

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Best Answer

    • Coach
      Answer ✓

      Try just the following:

      1. ADDTIME('timeplaced','timeEstimate'*60)

      AddTIME expects the first parameter to actually be a datetime value, so no need for you to convert anything there. It expects the second parameter to be in seconds, which is why I am multiplying your minute number by 60.

      **Check out my Domo Tips & Tricks Videos

      **Make sure to <3 any users posts that helped you.
      **Please mark as accepted the ones who solved your issue.

    Answers

    • Coach

      Try this:

      DATE_ADD(`timePlaced`, INTERVAL `timeEstimate` MINUTES)

      **Was this post helpful? Click Agree or Like below**
      **Did this solve your problem? Accept it as a solution!**
    • Coach
      Answer ✓

      Try just the following:

      1. ADDTIME('timeplaced','timeEstimate'*60)

      AddTIME expects the first parameter to actually be a datetime value, so no need for you to convert anything there. It expects the second parameter to be in seconds, which is why I am multiplying your minute number by 60.

      **Check out my Domo Tips & Tricks Videos

      **Make sure to <3 any users posts that helped you.
      **Please mark as accepted the ones who solved your issue.
    • Member

      Ah, I was over complicating my formula, goof time know ADD_TIME uses datetime not time values only.

      Thanks!

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Quick Links

    Categories